how to capture rejected data by using join stage not for
lookup stage. please let me know
Answer Posted / prasad
Instead of Transformer, use filter stage, it will gain performance
In Filter stage: use two Links
1st link: Where(clause)=column_name<>''
2nd link: Where=column_name='' (Reject data)
U will get O/P
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How do you register plug-ins?
Differentiate between datastage and informatica?
What is staging variable?
Which commands are used to import and export the datastage jobs?
How the ipc stage work?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
If you want to use a same piece of code in different jobs, how will you achieve this?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Can you explain repository tables in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the method of removing duplicates, without the remove duplicate stage?
On which Dimension Table you implemented SCD Type in your Project
What are the difference types of stages?
What are the processing stages?