Multiple choice technology

If you want to create indexes after the load process which transformation you choose?

  1. Filter Transformation

  2. Aggregator Transformation

  3. Stored procedure Transformation

  4. Expression Transformation
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Stored Procedure transformation allows you to call stored procedures in the target database after the load process, which can include creating indexes. You can configure it to run post-session or on a row-by-row basis. Filter (A) is for conditional filtering. Aggregator (B) performs grouping and aggregation. Expression (D) performs row-level calculations. None of these can execute DDL commands like CREATE INDEX.

Keep practicing — related questions