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 / 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
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?
Explain joiner transformation in informatica
Have you worked with/created Parameter file
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a dimensional model?
Describe data concatenation?
What is a node in Informatica?
How to create or import flat file definition in to the warehouse designer?
What are the data movement modes in informatica?
What is a predefined event?
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 are the types of lookup transformation?
In informatica workflow manager, how many repositories can be created?
differences between service based and product based?
difference between informatica 8.1.1 and 8.6