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 / jaspreet banga
Dynamic lookup means the lookup transformation will lookup
in the lookup table during mapping execution using session
i.e.,during runtime, example 'WHEN WE WANT TO GENERATE
PRIMARY KEY AND FOR THAT WE HAVE TO USE UNCONNECTED LOOKUP
TRANSFORMATION FOR LOOKING UP INTO THE TARGET FOR EACH NEW
ROW AND THAT IS DYNAMIC LOOKUP OR RUNTIME LOOKUP'. SCD type
2 indicates history preservation of records i.e.., update
the existing record using last update date and inserting
its new instance with new key. it dosent matter to use with
SCD1 or SCD2 we can use it as per our requirement. one more
example is "loading fact tables by looking up into
dimension tables"
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Target increases every day even though no new record was inserted
Separate from an archive server and a powerhouse?
What are the features of complex mapping?
Which files are created during the session rums by informatics server?
What are the new features of Power Center 5.0?
Explain what are the different types of transformation available in informatica.
Explain the types of lookup transformation?
What are active transformations.
What is mapping debugger?
Write the advantages of partitioning a session?
What are the differences between joiner transformation and source qualifier transformation?
What is sq transformation?
What are the uses of etl tools?
define galaxy repository in informatica
What do you mean by enterprise data warehousing?