i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100
i want target like
target1
deptno,sal
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100
with out using transformerstage
Answer Posted / naveen
seq1---------seq2
seq1 read the file.
seq2 ----give outfile1 and click on file give outfile2 then partition tab then select roun rabin partition key first column.
get the desired output.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the roundrobin collector?
Define ds designer?
Nls stands for what in datastage?
How to read the length of word in unix?
Which warehouse using in your datawarehouse
Differentiate between hash file and sequential file?
how many rows sorted in sort stage by default in server jobs
What is ds designer?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the difference between the local container and shared container?
Why do we use exception activity in Datastage?
Can you explain players in datastage?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How can one find bugs in job sequence?
what are the errors,warnings in datastage