how to capture rejected data by using join stage not for
lookup stage. please let me know
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
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What are the functionalities of link collector?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
which r the connectors used in san?
Explain datastage architecture?
What is orabulk stage?
Differentiate between datastage and informatica?
What are the different options associated with dsjob command?
What are the types of views in datastage director?
What is the purpose of interprocessor stage in server jobs?
What is a merge in datastage?
What is the sortmerge collector?
Lookup constraints
What is the roundrobin collector?
What is the difference between orabulk and bcp stages?