When using a customized reverse knowledge module, can the execution be done only on the development environment? A. No, all environments linked to a logical schema can be used to reverse-engineer table structure, B. No, only the production environment can…
Identify three objects from which scenarios can be generated. A. Interface B. Variable C. Package D. Knowledge modules E. Trail F. Extract
Identify one correct statement regarding Exception steps in Load Plans. A. Exception steps cannot be defined in a Load Plan. B. Exception steps can only be defined for Parallel Steps in a Load Plan C. Exception steps can only be…
Do all project developers using ODI need to consolidate their own local metadata repositories? A. No, ODI uses a centralized relational metadata repository that all the developers share. B. No, ODI proprietary metadata server allows all developers to share the…
Select the two correct statements about the Date Profiler. A. It can profile string dates written in a variety of formats, such as DD/MM/YYYY or MM/DD/YYYY. B. It provides a distribution for the day in the year, such as February…
You are loading a file into a database but the file name is unknown at design time and will have to be passed dynamically to a Package at run time; how do you achieve this? A. Create a variable, use…
You want to add a new CDC subscriber in ODI after you have started the Journal process, what steps do you need to go through in order to use this new subscriber? A. Drop Journal, remove existing subscribers, add a…
To use ODI efficiently in a Data Warehouse project is it necessary to have a topology with an intermediate transformation server? A. It is mandatory to have an intermediate server. B. It is better to load data directly from sources…
When working with delimited flat files, is it possible to enforce primary key on a flat file using a CKM? A. No, it is not possible to enforce constraints on some technologies such as flat files and JMS queues. B.…
Identify two true statements regarding the ODI SDK. A. The ODI SDK is used to load data between Teradata and Oracle. B. The ODI SDK can be used to embed ODI processes into another product. C. The ODI SDK is…