Multiple choice technology platforms and products

Which one of the following doesn’t represent a 'Transform' component of ETL?

  1. Rounding decimal values to Integers

  2. Removing special characters from a Text field

  3. Defining Primary Key constraint on a Table

  4. Assigning a default value to a field.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Defining a Primary Key constraint is a database schema operation, not a data transformation. The other options (rounding decimals, removing special characters, assigning default values) are all data transformations that modify the data itself during the ETL process. Constraints are structural, not transformational.

Keep practicing — related questions