You need to implement security mechanisms that allow only user “A” to view all the Mappings contained in a specific project named “P1.” How must you proceed? (Choose the best answer.)
A. Go to Security, assign the NG DESIGNER profile to user A. Next, drag project P1 to user A and finally setView privilegesto Active for the Mapping objects.
B. Go to Security, assign the DESIGNER profile to user A. Next, drag project P1 to user A and finally set View privileges to Active for the Mapping objects.
C. Go to Security, assign the NG DESIGNER profile to user A. Next, drag project P1 to user A and finally set View privileges to Active for the Project, Folder, and Mapping objects.
D. Go to Security, assign the DESIGNER profile to user A. Next, drag project P1 to user A and finally set View privileges to Active for the Project, Folder, and Mapping objects.
Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)
A. Data transformation must be distributed across several scalable nodes.
B. It is mandatory to have an intermediate server.
C. It is better to load data directly from sources into a data warehouse server.
D. It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.
Answer:
C
User Votes:
A
50%
B
50%
C 3 votes
50%
D
50%
Discussions
0/ 1000
Question 11
The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this? (Choose the best answer.)
You have to loop through a Mapping step three times in a package by using variables. Identify the correct variable data type to create the loop. (Choose the best answer.)
You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI. What must you do to accomplish this? (Choose the best answer.)
A. In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.
B. You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected.
C. You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI.
D. You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers.
Answer:
B
User Votes:
A
50%
B 2 votes
50%
C
50%
D 2 votes
50%
Discussions
0/ 1000
Question 15
Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)
A. Theintermediate integration table prefixed with I$is required to determine which records must be inserted.
B. IfFlow Control is not necessary, an I$ table is not created.
C. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.
D. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.
C uncheck box to not log