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 is the difference between in process and inter process?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result "SCH-AS" in onee column and "1010" in another column.. Can any one tell the answer...
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
what is .dsx files
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
CHANGE CAPTURE
what is the use of DSattchJob?DetachJob? where can we find it?
what is a nodemap constraint
Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?