What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
Answer Posted / datastage4you
In lookup, there is condition, condition not met, lookup not met need to fill.
So, if you have given any condition on input column does not met -> that will be handled by condition not met
and if lookup (join keys) failed with ref data -> lookup not met
Thanks
www.datagenx.net
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can you explain kafka connector?
What are system variables and sequencers in datastage
How many types of stage?
How to perform incremental load in datastage?
Lookup constraints
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the various kinds of containers available in datastage?
Define Merge?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Differentiate between validated and Compiled in the Datastage?
Name the different types of Lookups in Datastage?
Is possible to create skid in dim,fact tables?
Where do you see different stages in the designer?
What is quality stage?
Why fact table is in normal form?