Want to pass your Oracle Data Integrator 12c Essentials 1Z0-448 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error.
Why did this happen? (Choose the best answer.)
A. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.
B. It is not possible to enforce constraints on any technology.
C. It is only possible to forward-engineer it to the flat file definition.
D. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed file.
A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to find out the current window ID.
In which database schema must you look to find this table? (Choose the best answer.)
A. the schema hosting the Work repository
B. the schema hosting theWork schema of the default schema defined for your source data server
C. the schema hosting the Staging Area
D. SYS
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.