Oracle Data Integrator 11g Certified Implementation Essentials - 1z1-482 Exam Questions

A. No,a targetcolumn can have multiple defined mappings. B. Yes, a target column can have a unique and well-defined mapping. C. Yes, a target column can have a unique definition, but an ODI procedure can define additional mappings for that column. D. No, a variable is used to evaluate if the target column can have more than one mapping.

A. Package B. Trail C. Extract D. Interface E. Variable F. Knowledge modules

A. No, datatypes are assigned by default as string variables. B. Yes, it is possible to declare it but only if it is a standard SQL datatype. C. Yes, it is possible but in any case, you need to forward-engineer the datatype via the JDBC driver. D. Yes, it is possible to declare it, and if the desired datatype is not in the list available, you can also add it into a Topology datatypes definition.

A. Yes, you have to compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server. B. Yes, you have to copy all the procedures generated into the development, test, and production servers. C. No, ODI Agent coordinates the execution of the commands prepared for the job, and executes them on the correct server. D. No, ODI prepares a package for the development environment.

A. Yes, before executing the interface, it is possible to set a flag to request the code simulation. B. Yes, but it is only possible to see a code simulation on ODI Console. C. No, that is a current limitation in ODI. D. No, but it is possible to query the metadata repository in order to see the generated code.

A. Create a variable, use odiRef.getStep()in the SQL query in its Refreshing tab; and add a variable as a Refresh Variable step into Package B. Create a variable, use odiRef. getPrevsteptog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into Package C. Create a variable, use odiRef .getPrevstepstatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into Package D. Create a variable, use odiRef.getinfooin the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into Package

A. Exception steps can only be defined for Parallel Steps in a Load Plan B. Exception steps can only be defined for Serial Steps in a Load Plan. C. Exception steps can be defined for most Step types in a Load Plan. D. Exception steps cannot be defined in a Load Plan.

A. No, ODI proprietary metadata server allows all developers to share the common metadata of a specific project. B. No, ODI uses a centralized relational metadata repository that all the developers share. C. Yes, you have to invoke a dedicated web service to synchronize the metadata using the Oracle Service Bus. D. Yes, the local metadata needs to be transmitted via FTP and synchronized with a dedicated proprietary engine, creating a common metadata model for all developers.