Multiple choice etl

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

Stored Procedure Transformation allows you to call database stored procedures within a mapping. To create indexes after loading data, you would use a stored procedure containing CREATE INDEX statements and execute it via this transformation after the data flow completes. Filter Transformation only filters rows, Aggregator performs aggregation, and Expression Transformation calculates values - none can execute DDL commands like CREATE INDEX. Only Stored Procedure Transformation can run arbitrary SQL including DDL for index creation.

Keep practicing — related questions