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
what is song in infrmatica...?
What are the designer tools for creating transformations?
Explian the Process of deployment groups in informatica
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is status code in informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can informatica load heterogeneous targets from heterogeneous sources?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the difference between source qualifier transformations source filter to filter transformation?
update strategy transformation in informatica
What is meant by LDAP users?
How to elaborate tracing level?
Enlist the tasks for which source qualifier transformation is used.