1z0-448: Oracle Data Integrator 12c Essentials Mapping Practice Questions

A Mapping that uses CDC does not load any source data and you want to check theSNP_CDC_SETtableto find out the current window ID. In which database schema must you look to find this table?(Choose the best answer.)

• AA. the schema hosting the Work repository
• BB. the schema hosting theWork schema of the default schema defined for your source data server
• CC. the schema hosting the Staging Area
• DD. SYS

If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK. What happens at run time when a Mapping gets executed?(Choose the best answer.)

• AA. All distinct entries are processes. Only the latest entry is processed based on theJRN_DATEfiel
• BB. Only the first entry is processed based on theJRN_DATEfiel. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table

You are designing a Mapping. How are target and source tables defined?(Choose the best answer.)

• AA. 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. Their definition is imported with a reverse-engineering process directly from databases and other source
• BB. Forevery load the definition of the tables used, their columns and constraints must be manually build. An external engine must be run to describe what metadata is needed for a Mappin