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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you remove duplicate values in datastage?

625


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1040


What are the main features of datastage?

660


How do you register plug-ins?

598


How many types of views are there in a datastage director?

832






Can you explain kafka connector?

771


Explain connectivity between datastage with datasources?

594


How a routine is called in datastage job?

603


what is use of SDR function?

4706


EXPLAIN SCD

960


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1896


Can you filter data in hashed file?

3341


What are the differences between datastage and informatica?

568


What are iconv and oconv?

771


What are sequencers?

616