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
- 20697 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
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is difference between join, merge and lookup stage?
What is a merge in datastage?
Explain Quality stage?
What is a merge?
How do you remove duplicate values in datastage?
How you can fix the truncated data error in datastage?
Give an idea of system variables.
How do you schedule or monitoring the job?
What are constraints and derivations?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
Explain connectivity between datastage with datasources?
What are the stages in datastage?
How one source columns or rows to be loaded in to two different tables?
What are orabulk and bcp stages?
