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
- 17604 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 data caches/ index caches?
Explain the scenario which compels informatica server to reject files?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
what is song in infrmatica...?
What is the difference between writing a joiner query in ANSI style and THETA style?
Which is the t/r that builts only single cache memory?
Enlist some properties of sessions.
How do you load first and last records into target table?
How to improve the performance of a session using sorter transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Describe data concatenation?
what is the difference between informatica6.1 and infomatica7.1
How would you copy the content of one repository to another repository?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is joiner change?
