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
Define Job control?
client know skid info?
what are the devoleper roles in real time? plz tell i am new to datastage....
What are the difference types of stages?
Name the different sorting methods in datastage.
How do you register plug-ins?
How a routine is called in datastage job?
What is a merge?
What is difference between join, merge and lookup stage?
Define orabulk and bcp stages?
On which Dimension Table you implemented SCD Type in your Project
I have a few records just I want to store data in to targets cycling way how?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4