Capgemini ODI Developer Interview Questions and Answers

Slowly changing dimension (SCD) is a concept in data warehousing that describes how dimensions change over time.

• SCD Type 1: Overwrites old data with new data, losing historical information.

• SCD Type 2: Keeps multiple versions of the same dimension, creating new records for each change.

• SCD Type 3: Keeps both old and new values in the same record, with separate columns for each version.

• SCD Type 4: Uses separate tables to ...read more

Check Knowledge Module is used in ODI to validate data before loading it into target tables.

• It is used to perform data quality checks on the source data

• It can be used to check for duplicates, missing values, data format, etc.

• It helps ensure that only clean and accurate data is loaded into the target tables

Knowledge Modules in ODI are reusable components that define the logic for performing specific tasks in the ETL process.

• Types include Loading Knowledge Modules, Integration Knowledge Modules, Check Knowledge Modules, Reverse-Engineering Knowledge Modules, and Service Knowledge Modules.

• Loading Knowledge Modules handle data loading into target tables.

• Integration Knowledge Modules handle data integration between source an...read more