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
- 17720 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
Explain in detail scd type 2 through mapping.
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What do you mean by enterprise data warehousing?
What are the different lookup cache(s)?
What is a passive transformation?
How would you join a node to the already existing domain?
what is the Default Source Option For Update Strategy Transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain informatica architecture - version 8 / 9
what are the Methods For Creating Reusable Transformations?
Can we create multiple integration service on single repository?
Name the different lookup cache(s)?
What is aggregate cache in aggregator transformation?
In informatica workflow manager, how many repositories can be created?
What is informatica worklet?
