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
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
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
table actions available in oracle connector?
Name the different sorting methods in datastage.
Differentiate between validated and Compiled in the Datastage?
How do you register plug-ins?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What are the various kinds of the hash file?
What is process model?
What are the types of hashed files in data stage
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Name the different types of Lookups in Datastage?
Is possible to create skid in dim,fact tables?
How many types of hash files are there?
Can you define merge?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?