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
How do you import and export the datastage jobs?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Give an idea of system variables.
what is repositery?
What is the project in datastage?
How many Key we can define in remove duplicate stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
Explain the situation where you have applied SCD in your project?
What is the difference between validated and compiled in the datastage?
What could be a data source system?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Can you explain players in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is meta stage?
What is the difference between operational data stage (ods) and data warehouse?