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 |
What are the some differences between 7.x and 8.x version of datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
What is the difference between account and directory options ?
what is diff b/w datastage 8.1,8.5,8.7?
How you Remove the Dataset in Unix?
what is the difference between datasatge and datastage TX?
How do you import and export data into datastage?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
Difference between sequential file and data set?