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
- 7500 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
If you want to use the same piece of code in different jobs, how will you achieve it?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How can you write parallel routines in datastage PX?
EXPLAIN SCD
How can we improve performance of data stage jobs?
Can you explain engine tier in information server?
What is the method of removing duplicates, without the remove duplicate stage?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Explain entity, attribute and relationship 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 ?
how to implement scd2 in datastage 7.5 with lookup stage
How complex jobs are implemented in datstage to improve performance?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the precedence of stage variables,derivations, and constraints?
