| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: What are the different Lookup methods used in Informatica?
|
| August 08, 2007 07:38:28 |
#8 |
| rudra |
Member Since: Visitor Total Comments: N/A |
RE: What are the different Lookup methods used in Info...
|
Hi!Lookups are two types: 1) Connected 2) Unconnected
Connected is further two types 1) Static 2) Dynamic connected lookup is used while returning single or multiple returning values, but unconnected can return only single return value. static and dynamic are the caches that can be configured during the session. in dynamic inserts and updates occurs in cache during the session while in static there will be no such process. remember whenever you use dynamic lookup, you have to place an update strategy transformation before the target table. |
| |
Back To Question | |
