A. Create a Data Server by using the File technology and specify the various record formats while reverse engineering the file.

B. Create a Data Server by using the Complex File technology, create annXSDfile by using the NativeFormat Builder, and then reverse engineer it in aModel.

C. Create a Data Server by using the XML technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.

D. Create a Data Server by using theFile technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.

A. Data transformation must be distributed across several scalable nodes.

B. It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.

C. It is mandatory to have an intermediate server.

D. It is better to load data directly from sources into a data warehouse server.

A. restart from failed tasks

B. exception handling

C. restart of an agent

D. native support for parallelism

E. support for Open Tools

A. Their definition is imported with areverse-engineering process directly from databases and other sources, but you must manually define all keys and constraints existing on the database.

B. An external engine must be run to describe what metadata is needed for a Mapping.

C. Their definition is imported with a reverse-engineering process directly from databases and other sources.

D. Forevery load the definition of the tables used, their columns and constraints must be manually built.

A. They retrieve code from the execution repository and request database servers, operatingsystems, or scripting engines for execution.

B. They schedule code from the execution repository and update log files after execution.

C. They update or modify code to be executed, check security, select database servers, and update log files after execution.

D. They schedule scenarios to be executed, check security, constraints and update log files after execution.

A. ODI sessions can be monitored in Enterprise Manager Cloud Control.

B. ODI Console provides access to project and mapping details.

C. Enterprise Manager Cloud Control provides access to ODI data servers' settings.

D. ODI Console allows administrators to edit users' information.

A. Right-click the step in Package Editor and select the No Logging menu item.

B. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.

C. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.

D. Modify Operator Navigator settings to disable that step from being displayed.

A. Only ODI variables can be used to filter the target table loading.

B. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.

C. It is not possible to use a specific partition.

D. An option in the Mapping can be used to declare the partition that has to be used for the loading.