Test COG-625: IBM Cognos 10 BI Data Warehouse Developer

The IBM Cognos 10 BI Data Warehouse Developer exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Data Manager and Data Warehousing (4%)

1. Identify how Data Manager can be used
2. Distinguish between OLTP systems and data warehouses

Catalogs and Data Source Connections (12%)

1. Describe the process of creating a catalog
2. Identify how to use SQLTerm
3. Describe how to configure text files using SQLTXT Designer
4. Describe how to package catalog components
5. Describe how to navigate through catalog components
6. Describe how to export catalog metadata to Cognos 8

Dimensions and Basic Hierarchies (7%)

1. Determine appropriate situations for using a hierarchy
2. Describe the use of the Reference Explorer tool
3. Describe the use of the Date Hierarchy wizard

Basic Dimension Builds and Fact Builds (12%)

1. Describe the types of builds
2. Describe the use of the Dimension Build wizard
3. Describe the process of creating a fact build
4. Describe the modification of build settings

Derivations and Derived Dimensions (6%)

1. Identify the benefits of creating a derivation
2. Determine the appropriate location to create a derivation
3. Identify when it would be useful to create a derived dimension

Conformed Dimensions (10%)

1. Describe the advantages of conformed dimensions
2. Describe surrogate keys
3. Describe how to deliver conformed dimensions
4. Describe how to check data integrity

Hierarchies and Lookups (8%)

1. Describe ways to modify hierarchies and lookups
2. Describe how to manipulate data using hierarchies and lookups

Dimensional History and Late Arriving Data (10%)

1. Describe the use of slowly changing dimensions (SCDs)
2. Describe the handling of late arriving fact and dimension data

Data Delivery and Data Processing (22%)

1. Describe delivering fact and dimension data
2. Describe how to merge and aggregate fact data
3. Describe how to restrict fact data delivery
4. Describe how to implement job control
5. Describe how to pivot fact data

User-Defined Functions (UDFs) and Variables (5%)

1. Describe how to create UDFs
2. Describe the use of variables

Troubleshooting and Tuning (4%)

1. Describe options to address memory and performance issues
2. Describe how to interpret the log files