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


Please Help Members By Posting Answers For Below Questions

Explain the different lookup methods used in informatica?

816


How do you use reject loader.

2346


What are the components of workflow manager?

820


Explain incremental aggregation in informatica

889


What is powercenter on grid?

961


What are active transformations.

1423


How can we delete duplicate rows from flat files?

993


how many types of dimensions are available in informatica?

767


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?

840


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

864


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1806


What are mapplets? How is it different from a Reusable Transformation?

875


can we override a native sql query within informatica? How do we do it?

874


What is resilience time?

856


How can we use mapping variables in informatica?

816