ETL process consists of extract, transform, and load. Transformation occurs by using ________ or lookup tables or by combining the data with other data.
A) rules
B) policies
C) strategies
D) procedures

Question

Quizplus · Accepted Answer

Transformation in ETL process is done using rules or transformation rules which are defined based on the business logic or requirements. The rules are applied to the extracted data for converting it into the desired form before loading it into the target system. Lookup tables and data concatenation are also examples of rule-based transformations. Policies, strategies, and procedures are not typically used in ETL transformation process.

ETL Process Consists of Extract, Transform, and Load