Online Access Free 1z0-448 Exam Questions

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

• A.The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.
• B.The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.
• C.The Knowledge Module must be customized only for aggregation functions.
• D.The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

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 need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific project.
• B.You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers.
• C.You need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.
• D.You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus.

Which tables created by ODI contain error records? (Choose the best answer.)

• A.ERROR$
• B.ODI_ERR$
• C.ERR$
• D.E$

Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)

• A.It is mandatory to collect data directly from sources to a data warehouse server by using real time replication processes.
• B.It is better to load data directly from sources into a data warehouse server.
• C.It is mandatory to have an intermediate server.
• D.Data transformation must be distributed across several scalable nodes.

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.
How must you test this by using ODI Studio running on machine C? (Choose the best answer.)

• A.UseOdiPingAgentin a package to ping AGT agent.
• B.In Topology, test the connections to servers A and B by using the AGT agent.
• C.In Topology, test the connections to the AGT agent.
• D.In Topology, test the connections to servers A and B by using Local (No Agent).