IBM Cognos 10 BI Data Warehouse Developer Set 1

To reduce memory usage, what should be done when setting up dimension breaking for a fact build?

During execution, a fact build generated the following messages in the log file: What can be done to avoid seeing the last three lines when the build is executed again?

What can be done to minimize memory consumption?

A dimension table tracks employee data. If an employee's work location changes, the previous work location needs to be kept and a new record needs to be created. What kind of change is this?

 

A dimension table contains the following data: If late arriving fact processing is enabled, what will be the value of the surrogate key assigned to the last row of fact data?

The data in the Product dimension table appears as follows: What is one of the things that must be done to ensure that all of these records are delivered into the dimension table?

A dimension table tracks employee data. If an employee's phone number changes, the old phone number does not need to be kept. What kind of change is this?

A developer wants to ensure that the business keys in incoming source data are replaced with surrogate keys in the fact tables. To do this, what must be modified?

Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?

When creating dimensions, what is commonly used to track historical changes?