What are the difference between Row-by-row select and Cached comparison table and sorted input in Table Comparison Transform? | SAP BO Interview Questions

=>    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.