Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)
A. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.
B. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.
C. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.
D. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.
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.
You need to create a package that automatically sends an alert to users in case the third step fails.
Which option represents the steps to accomplish this? (Choose the best answer.)
A. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a green OK arrow.
B. Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arrow.
C. Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KO arrow.
D. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KO arrow.
Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)
A. Run Exception and Restart
B. Run Exception and Continue
C. Run Exception and Ignore
D. Run Exception and Fail
E. Run Exception and Raise
How do you reuse a configuration of OdiSendMail across multiple packages? (Choose the best answer.)
A. Add a sub-model to a package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
B. Add anOdiSendMailstep to a knowledge module.
C. Duplicate theOdiSendMail stepinto multiple packages.
D. Create a procedure with a step that usesOdiSendMailand add this procedure into multiple packages.
When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs? (Choose the best answer.)
A. transform only
B. load and transform
C. extract and load
D. extract and transform
You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.
What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)
A. Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.
B. Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.
C. Duplicate the source data store for each Mapping.
D. Create two distinct subscribers for each Mapping.
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.)
A. All distinct entries are processed.
B. Only the latest entry is processed based on theJRN_DATEfield.
C. Only the first entry is processed based on theJRN_DATEfield.
D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.
You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed.
What sequence of steps must you follow to achieve this? (Choose the best answer)
A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design.
B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design.
Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)
A. It enables developers to execute most ODI operations through a Java program.
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 must be used by ETL developers to develop ODI processes.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-448 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.