What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
Answers were Sorted based on User's Feedback
Answer / duser
Condition Not Met Option will be applicable only if the condition check is provided under Condition Heading.If such a check not provided,then values in the Condition Not Met tab will not make any difference.
| Is This Answer Correct ? | 5 Yes | 0 No |
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 |
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
how to sort two columns in single job in datastage.
How to remove blank spaces from data?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
whats difference between ls -ltr and ls -lrt?
What is datastage?
What is the method of removing duplicates, without the remove duplicate stage?
how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel
I have a few records just I want to store each records tow times in target how?
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
How did you reconcile source with target?
how to identifie,is it innerjoin,leftouter join in lookup?