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

Stored Procedure transformation can execute database procedures after data loading completes, making it ideal for creating indexes on target tables. Filter and Expression transformations operate on row-level data during pipeline flow and cannot execute DDL commands like CREATE INDEX. Aggregator transformation is for summarizing data, not post-load operations.

Keep practicing — related questions