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
- 17857 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
What is domain in terms of informatica?
How many ways a relational source definition can be updated and what are they?
What is decode in informatica?
difference between informatica 8.1.1 and 8.6
Explain in detail about scd type 1 through mapping.
Enlist few areas or real-time situations where informatica is required.
Write the program through which the records can be updated?
Explain the pipeline partition with real time example?
what are the Methods For Creating Reusable Transformations?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Describe data concatenation?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is joiner transformation?
What is meant by pre and post session shell command?
What are multi-group transformations?
