Online Access Free 1z1-448 Practice Test

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 only possible to forward-engineer it to the flat file definition.
• B.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.
• C.It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) queries.
• D.It is not possible to enforce constraints on any technology.

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

• A.It must be used by ETL developers to develop ODI processes.
• B.It can be used to embed ODI processes into another product.
• C.It is used to load data between Teradata and Oracle.
• D.It enables developers to execute most ODI operations through a Java program.

Your package logic requires you to retrieve the status of the previous package step into a variable.
How must you implement this? (Choose the best answer.)

• A.Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
• B.Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
• C.Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.
• D.Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

Identify two correct statements about reusable Mappings. (Choose two.)

• A.They can be shared across projects.
• B.They can have generic input and output signatures.
• C.They can be executed directly.
• D.They can be used within regular Mappings.
• E.They contain both a Logical and Physical Mapping design.

You are designing a load plan in which you must create multiple branches based on the value of a variable. How do you accomplish this by using Load Plan Editor? (Choose the best answer.)

• A.Create a scenario from the variable and add the scenario to the load plan to create a case step.
• B.Add a case step in the load plan and select a variable in the wizard.
• C.Add a case step and drag the variable into the case step.
• D.Drag the variable into the load plan and define a case step.