Multiple choice technology platforms and products

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 SQL scripts after data loading, including index creation. Filter and Expression transformations operate row-by-row during pipeline flow, while Aggregator performs group operations. Stored procedures are specifically designed for post-load database operations like creating indexes.

Keep practicing — related questions