Multiple choice technology platforms and products

Table comparision transformation produces the following type of record types

  1. Insert,Update,Delete,Normal

  2. Insert,Update,Normal

  3. Insert,Update,Delete

  4. Insert,Update,Delete,Reduce
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Table comparison transformation in ETL tools like Informatica produces four record types: Insert (new rows in target), Update (changed rows), Delete (rows removed from source), and Normal (unchanged rows that pass through). The Normal flag identifies rows that matched but had no changes, which is useful for auditing and tracking processing statistics.

Keep practicing — related questions