Free Oracle 1z1-482 Exam Dumps Questions & Answers

Is it possible to import a knowledge module into project (A) and then reference that knowledge module in another project (B)?

• A.Yes, knowledge modules can be imported.
• B.Yes, but three specific variable;; have to be declared to indicate the data environment.
• C.No,because a variable needs to be set to define it as a global knowledge module-
• D.No, to use a knowledge module, it must be imported into each project.

Which tables store ODI/OBIEE lineage information?

• A.Work repository tables
• B.Master repository tables
• C.Staging tables
• D.OBIEE repository tables

In an ODI interface, can source tables be declared as not joined?

• A.No, in ODI, it is mandatory that all the source data stores are joined directly or indirectly.
• B.Yes, it is possible to create an ODI procedure to declare joins for the source tables.
• C.Yes, ODI generates the code calculating a sample of the data, profiling it, and deciding automatically if a join exists.
• D.No, by default, every added data store in the source declaration of an interface is joined with an inner join.

Updates have been made to Interfaces in a Package. What would you do to make sure the Production team runs a scenario containing those updates while preserving the existing scenario's schedule?

• A.Nothing, the existing scenario will get automatically updated
• B.Regenerate existing scenario
• C.Generate a new scenario and create a new schedule
• D.Generate a new scenario and attach the previous scenario's schedule to it

One of the parameters retrieve column properties in a knowledge module is odiRef.getcolList.
What is the name of the parameter that retrieves the datatype of a mapped target column?

• A.SOURCE_DT
• B.COL_DESC
• C.COL_FORMAT
• D.DEST_DT