What Are The Differences Between Row-by-row Select And Cached Compari

1.	What Are The Differences Between Row-by-row Select And Cached Comparison Table And Sorted Input In Table Comparison Transform?
Answer» Row-by-row select - look up the TARGET table using SQL every time it receives an input row. This option is best if the target table is large. Cached comparison table — To LOAD the comparison table into memory. This option is best when the table fits into memory and you are comparing the entire target table Sorted input — To read the comparison table in the order of the primary key column(s) using sequential read.This option improves performance because DATA Integrator reads the comparison table only once.Add a query between the source and the Table_Comparison transform. Then, from the query’s input SCHEMA, drag the primary key columns into the Order By box of the query.

What Are The Differences Between Row-by-row Select And Cached Comparison Table And Sorted Input In Table Comparison Transform?

Answer»

Row-by-row select - look up the TARGET table using SQL every time it receives an input row. This option is best if the target table is large.
Cached comparison table — To LOAD the comparison table into memory. This option is best when the table fits into memory and you are comparing the entire target table
Sorted input — To read the comparison table in the order of the primary key column(s) using sequential read.This option improves performance because DATA Integrator reads the comparison table only once.Add a query between the source and the Table_Comparison transform. Then, from the query’s input SCHEMA, drag the primary key columns into the Order By box of the query.