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
- 17753 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
How do you promote a non-reusable transformation to reusable transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Different sorts of metadata that stores in the storage facility?
Can you generate sequence numbers without using the sequence generator transformation?
Why update strategy and union transformations are active? Explain with examples.
In informatica workflow manager, how many repositories can be created?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Differentiate between source qualifier and filter transformation?
what is song in infrmatica...?
What is the procedure for creating independent data marts from informatica 7.1?
What is a predefined event?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How do you load only null records into target? Explain through mapping flow.
How can we remove the duplicates from flat file source?
Design time, run time. If you don't create parameter what will happen
