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
- 17572 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 the difference between STOP and ABORT options in Workflow Monitor?
What are the different components of powercenter?
How you prepared reports for OLAP?
4 yrs etl devloper roles and responsibilities?any body give solutions
whats the logic to load the lower level of granularity of data to fact table.
Briefly define reusable transformation?
What is substr in informatica?
How we can create indexes after completing the load process?
What is the meaning of decode in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is resilience time?
Target increases every day even though no new record was inserted
How will the document be delivered to me?
What are the types of schemas we have in data warehouse and what are the difference between them?
