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
- 17630 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 3 tech challenges/ common issues you face?
What is primary and backup node?
What happens when a session fails and you click on recover?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is dynamic cache?
write a query to retrieve the latest records from the table sorted by version(scd)
What will be the approach?
How to load the data from people soft hrm to people soft erm using informatica?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How many numbers of sessions can one group in batches?
What is the need for an etl tool?
What is the use of target designer?
How do we call shell scripts from informatica?
Define enterprise data warehousing?
What is difference between a gateway node and worker node?
