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
- 10399 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
what is flow of project?
Can we use target hash file as a lookup ?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is orabulk stage?
What is the project in datastage?
Can you explain link buffering?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What are the different options associated with dsjob command?
Describe routines in datastage? Enlist various types of routines.
Why do we use link partitioner and link collector in datastage?
Could anyone give brief explanation bout datastage admin
what is 'reconsideration error' and how can i respond to this error and how to debug this
Difference between in process and inter process?
Enlist various types of routines in datastage.
