Online Access Free C_BODI_20 Exam Questions

Which two tasks must you perform to ensure the businessObject universe Bolder transfers the correct metadata lineage information? (Choose two)

• A.Calculate column mappings
• B.Calculate table mappings
• C.Calculate usage dependencies
• D.Calculate column dependencies

You want to join a "sales", "customer" and "product" table. Each table resides on a different data store and will not pushdown to one SQL command. The "sales" table contains approximately five millions rows. The "customer" table contains approximately five thousand rows. The "product" table contains fifty records.
How would you set the source table options to maximize performance of this operation?

• A.Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 10 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
• B.Set the sales table joins rank to 20 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".
• C.Set the sales table joins rank to 10 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 30 and cache to "yes".
• D.Set the sales table joins rank to 30 and cache to "No". Set the customer table joins rank to 20 and cache to "yes". Then set the product table join rank to 10 and cache to "yes".

You have a source table that contains fifty columns. You need to place business rules on thirty of the columns to check the format of the source data and filter the valid and invalid records. You also want to analyze the column values that fail. What is the recommended method you should use?

• A.Use a Validation transform and enable validation rules on the required columns
• B.Use two Query transforms with different WHERE clauses to filter the invalid records
• C.Use a Map_Operation transform to map valid and invalid data rules
• D.Use a Case transform to create two conditions that filter the invalid records

Which lookup function returns multiple columns?

• A.Lookup_Seq
• B.Lookup _Adv
• C.Lookup
• D.Lookup_Ext

Which three operations can Data Integrator push down to the underlying database? (Choose three)

• A.Ordering
• B.Union
• C.Distinct Row
• D.Aggregation