Multiple choice technology

Which transformation can be used for dynamic updation of the target column values

  1. Java

  2. Custom

  3. SQL

  4. Update strategy
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL Transformation allows dynamic execution of SQL queries at runtime, making it ideal for updating target column values based on complex logic or lookups that can't be handled by standard transformations. Unlike Update Strategy which only flags records for insert/update/delete, SQL Transformation can execute actual UPDATE statements with dynamic conditions.

Keep practicing — related questions