What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
- 2 Answers
- 15622 Views
- I also Faced
- E-Mail Answers
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 is difference between join, merge and lookup stage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Differentiate between operational datastage (ods) and data warehouse?
What is PX?
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
how to run a sequential file stage in parallel if the stage is used on the TARGET side
1)Source file contains one record, I want 100 records in target file.
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
How many Key we can define in remove duplicate stage?
what r the sources u need to create the datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
what is executable in DataStage?
Teradata 
