What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

Answers were Sorted based on User's Feedback



What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example...

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

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example...

Answer / datastage4you

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

Post New Answer

More Data Stage Interview Questions

What is the difference between in process and inter process?

0 Answers  


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?

3 Answers   Caterpillar,


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...

5 Answers  


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?

0 Answers   Wipro,


what is .dsx files

3 Answers   IBM,






WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,


CHANGE CAPTURE

0 Answers   CTS,


what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,


what is a nodemap constraint

2 Answers   IBM,


Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,


IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?

3 Answers   Infosys,


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?

2 Answers  


Categories