Hi,

Lookup transformation points any one of the table. It may be relational table or flat file. Other transformations points the column of any table.

Using lookup transformation, we can transverse or search the value in the particular table.

Please get back to me in case of queries.

Thanks & Regardsm
Prakash Chandran