KPIT Technologies Quality Engineer Interview Questions and Answers

ETL stands for Extract, Transform, Load. It is used to extract data from various sources, transform it into a consistent format, and load it into a data warehouse for analysis.

• Extract: Data is extracted from different sources such as databases, files, or APIs.

• Transform: The extracted data is cleaned, filtered, and transformed into a consistent format.

• Load: The transformed data is loaded into a data warehouse for analys...read more

SCD types refer to slowly changing dimensions in data warehousing, used to track historical changes in data over time.

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

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

• SCD Type 3: Keeps some historical data in the same record, adding new columns for changes.

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