ETL Testing ETL Data Transformation Rules 3

Question 1

Which transformation is applied to identify and merge duplicate records into a single canonical record?

Accepted Answer

Deduplication / Master Data Management merge

Answer

Deduplication transformations identify matching records based on key attributes and consolidate them into a single master record.

Question 2

In ETL testing, what does a 'negative test case' for a transformation rule validate?

Accepted Answer

That invalid or out-of-range input data is rejected or flagged as expected

Answer

Negative test cases verify that the transformation correctly rejects, flags, or routes invalid data rather than silently passing bad values to the target.

Question 3

What is 'pivoting' in the context of ETL transformation?

Accepted Answer

Converting rows to columns or columns to rows to reshape the data structure

Answer

Pivoting reshapes data by transposing rows into columns (or vice versa), commonly used to convert normalized transactional data into a wide analytical format.

Question 4

When a transformation maps source code '1' to 'Active' and '2' to 'Inactive', what type of transformation is this?

Accepted Answer

Code/value lookup or mapping

Answer

Code mapping or value lookup transformations translate numeric or coded source values into their human-readable target equivalents using a lookup table.

Question 5

Which test approach verifies that an ETL transformation produces the correct output for ALL documented business rules simultaneously on a sample dataset?

Accepted Answer

End-to-end transformation regression test

Answer

An end-to-end transformation regression test runs a known dataset through the full transformation chain and compares results against expected outputs for all rules at once.

ETL Testing - extract, transform, load Practice Test

ETL Testing - extract, transform, load Practice Test

ETL Testing ETL Data Transformation Rules 3