Interested to Buy Any Domain ? << Click Here >> for more details...
how to capture rejected data by using join stage not for
lookup stage. please let me know
- 3 Answers
- 20812 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / karn khera
Use FULL OUTER JOIN....the non matching records will be having null values....after join put a transformer and collect rejected data by Isnull() function..... cheers :)
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
Can we use target hash file as a lookup ?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How a source file is populated?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are routines in datastage?
What is the differentiate between data file and descriptor file?
What is a merge in datastage?
What are the components of datastage?
What is the difference between validated and compiled in the datastage?
Why do you need stage variables?
What are the areas of application?
Explain usage analysis in datastage?
What steps should be taken to improve Datastage jobs?
Explain the situation where you have applied SCD in your project?
