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

Aggregation

Answer

Pivoting

Answer

Type casting

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

That records with negative numeric values are handled correctly

Answer

That the ETL job fails gracefully under load

Answer

That null values produce negative outputs

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

Rotating the data warehouse server for maintenance

Answer

Sorting records by a pivot key column

Answer

Combining two source tables on a common key

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

Aggregation

Answer

Type casting

Answer

Deduplication

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

Unit testing individual transformations in isolation

Answer

Load volume test

Answer

Schema drift test

Question 6

In ETL transformation testing, 'boundary value testing' for a transformation that caps sales amounts at $10,000 would test which values?

Accepted Answer

$9,999, $10,000, and $10,001

Answer

Only $5,000 (midpoint)

Answer

Only values below $1,000

Answer

Only null and zero