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
Explain the different lookup methods used in informatica?
How do you use reject loader.
What are the components of workflow manager?
Explain incremental aggregation in informatica
What is powercenter on grid?
What are active transformations.
How can we delete duplicate rows from flat files?
how many types of dimensions are available in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are mapplets? How is it different from a Reusable Transformation?
can we override a native sql query within informatica? How do we do it?
What is resilience time?
How can we use mapping variables in informatica?