Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 10115 Views
- I also Faced
- E-Mail Answers
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
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is size of a transaction and an array means in a datastage?
Give an idea of system variables.
How to manage date conversion 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.
What are the some differences between 7.x and 8.x version of datastage?
Name the different sorting methods in datastage.
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the stages in datastage?
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?
which r the connectors used in san?
Explain how a source file is populated?
How can we improve the performance in datastage?
What can we do with datastage director?
What are the different types of lookups in datastage?
