Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 17574 Views
- Amdocs, I also Faced
- E-Mail Answers
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
What are the new features of informatica 9.x at the developer level?
Can you generate sequence numbers without using the sequence generator transformation?
What is incremental aggregation?
What is the surrogate key?
How to update a particular record in target with out running whole workflow?
Which version configuration tool used in ur project?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the guidelines to be followed while using union transformation?
What is dynamic cache?
How do you handle two sessions in Informatica
How do you take back up of repository?
How do you load first and last records into target table?
Which transformation should we use to normalise the COBOL and relational sources?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the components of workflow manager?
