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
Define Data Stage?
How to clean the datastage repository?
describe the Steps to confiure a Qlogic switch
Can you explain players in datastage?
Is possible to create skid in dim,fact tables?
What are the areas of application?
What steps should be taken to improve Datastage jobs?
How do y read Sequential file from job control?
why do u need the IOS upgradation in a FC switch
What is the purpose of interprocessor stage in server jobs?
What is the difference between validated and compiled in the datastage?
What are routines in datastage?
Name the third party tools that can be used in datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Describe the main features of datastage?