Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.
- 2 Answers
- 15535 Views
- I also Faced
- E-Mail Answers
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 the join and look up explin me one exmple
What is a ds designer?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
What is the differentiate between data file and descriptor file?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
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 steps should be taken to improve Datastage jobs?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
Teradata 
