source
1123445
I WANT OUTPUT AS
DUPLICATES TO TARGET1 LIKE
TARGET1
1144
NON-DUPLICATES TO TARGET2
TARGET2
235
Answer Posted / siva
seq.file-->copy-->agg
! !secondary link
!.....>join-------->filter-->t1
primarylink !---->t2
agg:countrows
give condition in filter
count=1-->t1
count<>1-->t2
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the types of hashed files in data stage
How to perform incremental load in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
How to clean the datastage repository?
Name the command line functions to import and export the DS jobs?
What are the areas of application?
describe the Steps to confiure a Qlogic switch
How a routine is called in datastage job?
project Steps,hits, Project level HArd things,Solved methods?
How can we improve performance of data stage jobs?
What are the types of jobs we have in datastage?
How many types of views are there in a datastage director?
How we can covert server job to a parallel job?
Explain the situation where you have applied SCD in your project?
What is a datastage job?