Where we use dynamic lookup and where we use it?do we
generate surrogate keys using dynamic lookup?can we use it
for scd type 2 mapping and why?
Answer Posted / riyaz
The following list describes some situations when you use a dynamic lookup cache:
Updating a master customer table with new and updated customer information. Use a Lookup transformation to perform a lookup on the customer table to determine if a customer exists in the target. The cache represents the customer table. The Lookup transformation inserts and update rows in the cache as it passes rows to the target.
Inserting rows into a master customer table from multiple real-time sessions. Use a Lookup transformation in each session to perform a lookup on the same customer table. Each Lookup transformation inserts rows into the customer table and it inserts them in the dynamic lookup cache. For more information about synchronizing dynamic cache between multiple sessions, see Synchronizing Cache with the Lookup Source.
Loading data into a slowly changing dimension table and a fact table. Create two pipelines and configure a Lookup transformation that performs a lookup on the dimension table. Use a dynamic lookup cache to load data to the dimension table. Use a static lookup cache to load data to the fact table, and specify the name of the dynamic cache from the first pipeline.
Reading a flat file that is an export from a relational table. Read data from a Teradata table when the ODBC connection is slow. You can export the Teradata table contents to a flat file and use the file as a lookup source. Configure the Teradata table as a relational target in the mapping and pass the lookup cache changes back to the Teradata table.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
What is the cumulative sum and moving sum?
What are different types of transformations available in informatica?
Separate from an archive server and a powerhouse?
can anyone explain me about retail domain project in informatica?
What are the differences between oltp and olap?
Where are the source flat files kept before running the session?
What are the features of complex mapping?
What is the session task and command task?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the different ways to implement parallel processing in informatica?
What is lookup transformation?
what are the Methods For Creating Reusable Transformations?
Did u used latest transformations of 8.6.0? for what?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not