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
- 17575 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 different types of transformation available in informatica.
Write the program through which the records can be updated?
what is the -ve test case in your project.
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How would you join a node to the already existing domain?
How to elaborate powercenter integration service?
What is InformaticaPowerCenter?
Mention some types of transformation?
What all join we can perform in LOOKUP transformation?
What will be the approach?
How to implement security measures using repository manager?
Explain the features of connected and unconnected lookup.
What is standalone command task?
What is mapping debugger?
What is the need for an etl tool?
