Interested to Buy Any Domain ? << Click Here >> for more details...
i hav source like this .
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100
i want target like this
target1
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100 with out using transformer
- 2 Answers
- 7422 Views
- I also Faced
- E-Mail Answers
Answer Posted / hari chowdary
by using partition technique round rabin we can do easily.
single source table,two target tables
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
How can we improve the performance in datastage?
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 the difference between operational data stage (ods) and data warehouse?
How many types of sorting methods are available in datastage?
How to manage date conversion in Datastage?
How can we improve performance of data stage jobs?
If you want to use the same piece of code in different jobs, how will you achieve it?
Differentiate between datastage and datastage tx?
What are the main features of datastage?
What are the different types of lookups in datastage?
What is the use of datastage director?
What steps should be taken to improve Datastage jobs?
Why do we use exception activity in Datastage?
options available in sequence job to run,validate?
What are the steps needed to create a simple basic datastage job?
