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
- 17850 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / nayan naik
Dynamic lookup when used in a SCD-2 implementation ,you must
make sure your lookup transformation is on the target table,
hence the dynamic lookup cache is always in sync.
Surrogate keys are generated using a sequence and not a
lookup transformation. Have a look at this link it gives you
a complete step by step implementation of SCD-2 in informatica.
http://deepinopensource.blogspot.in/2013/03/scd-2-implementations-in-informatica.html
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the databases that informatica can connect to windows?
How can we delete duplicate rows from flat files?
How to load the data from people soft hrm to people soft erm using informatica?
What is dynamic cache?
What is the way to execute pl/sql script using informatica mapping?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
tell me about your project functionality
Suppose we do not group by on any ports of the aggregator what will be the output?
Which development components of informatica have the highest usage?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the difference between a connected look up and unconnected lookup?
What is repository manager?
Explain lookup transformation is active in informatica
Where is metadata stored?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
