Lookup transformation is used to looking up the relational tables,flat files ,views,synonyms.Mainly lookup is used in creating fact table.
ex:
while loading fact table , take the transaction table and take the dimension table as lookup and give the condition in lookup for to check whether that transaction table having related data (information) and load that data to fact table.
Regards
Amaran