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 A Datastage?

2 Answers  


What is "fatal error/rdbms code 3996" error?

0 Answers  


1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

6 Answers   CTS, HCL, IBM, Wipro,


How to lode data in sequntional files perform faster?

1 Answers   Polaris,


I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,






iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,


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

4 Answers   TCS,


HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers   IBM,


data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,


Which type of joins Merge stage can support?

7 Answers   IBM,


Tell me the syntax of Configuration file?

1 Answers  


I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,


Categories