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 |
A flatfile 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 the job?pls give the steps?
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz
What is the use of datastage designer?
what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
why we use hash file for lookup?
How to display errors in datastage?
how to define satge variables in transformer stage
which dim, fact tables used in bank domain
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
Describe link sort?