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…
Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality. How can you achieve this? (Choose the best answer.) A. The project must be…
Which tables created by ODI contain error records? (Choose the best answer.) A. ERR$ B. ERROR$ C. ODI_ERR$ D. E$
You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.) A. Create a custom KM to handle this by using ODI variables defined at the Topology level…
How are the ODI repositories upgraded? (Choose the best answer.) A. by using Opatch B. by using ODI Studio C. by using the import/export utilities D. by using Upgrade Assistant
You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed? (Choose the best answer.) A. Create a single Mapping with two Physical Designs: one…
How should you define the Work Schema of a Physical Schema? (Choose the best answer.) A. Use a dedicated schema such as ODI_STAGING. B. Use TEMP. C. Use the same schema as the Data Schema. D. Use SYSTEM.
You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement. (Choose the best answer.) A. You must consolidate your own local metadata repositories. The local metadata must be transmitted via…
How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best answer.) A. from the source database into flat files that are then loaded into…
Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.) A. extracting source data to flat files B. triggers C. Oracle GoldenGate D. before-and-after database image comparison