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

A Stored Procedure transformation is typically used to create indexes after data loading because index creation on large tables is more efficient after the load completes (reduces overhead during load). Stored procedures can execute DDL commands like CREATE INDEX. Filter, Aggregator, and Expression are data manipulation transformations.

Keep practicing — related questions