Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - Explain about Lookup transformation? How many types of lookup transformation available in informatica?




606
views
asked SRVMTrainings December 18, 2011 05:56 AM  

Explain about Lookup transformation? How many types of lookup transformation available in informatica?


           

2 Answers



 
answered By SRVMTrainings   0  
We use lookup transformation to lookup data from a relational table, view, synonym or flatfile against another or the same table, view, synonym or flatfile. This is mainly(not only)used for SCDs. So that the value in the source can be compared with the existing target. Lookup transformation are of different types named and unnamed. Mostly used lookup transformation types are Connected lookup (Persistent Lookup, Dynamic lookup, Cached lookup, Uncached lookup)
flag   
   add comment

 
answered By SRVMTrainings   0  
Lookup is a transformation to look up the values from a relational table/view or a flat file. The developer defines the lookup match criteria. There are two types of Lookups in Powercenter-Designer 1) Connected Lookup 2) Unconnected Lookup. Different caches can also be used with lookup like static, dynamic, persistent, and shared.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert