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