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
- 17623 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 is INFORMATICA TESTING process
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Is there any target staging area in informatica not staging area
What is a joiner transformation and why it is an active one?
What is blocking transformation?
Different sorts of metadata that stores in the storage facility?
How can we use mapping variables in informatica?
Explain the types of lookup transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
wat are deployement groups in informatica, how it will be used for developers
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is confirmed fact in dataware housing?
What is meant by pre and post session shell command?
Which are the different editions of informatica powercenter that are available?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
