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
- 17715 Views
- Amdocs, I also Faced
- E-Mail Answers
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
Write the prerequisite tasks to achieve the session partition?
During the running session, output files are created by informatica server. Enlist few of them.
Write the advantages of partitioning a session?
Clarify the utilization of aggregator cache record?
What are the components of workflow manager?
What is mapplet in informatica?
update strategy transformation in informatica
What are the different transaction levels available in transaction control transformation?
What is the reusable transformation?
How might one distinguish in the case of mapping is right or not without associating session?
How can we use mapping variables in informatica? Where do we use them?
What is target load order?
How to open an older version of an object in the workspace?
Enlist the various types of transformations.
Briefly describe lookup transformation?
