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
- 17748 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
How do you migrate data from one environment to another?
What is domain and gateway node?
Explain the shared cache and re-cache?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How can we use mapping variables in informatica? Where do we use them?
What is the status code in stored procedure transformation?
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 is the difference between Active and Passive transformation?
According to his methodology what all you need before you build a datawarehouse
What do mean by local and global repository?
What are the new features of informatica 9.x at the developer level?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Performance tuning( what you did in performance tuning)
Separate from an archive server and a powerhouse?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
