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


Please Help Members By Posting Answers For Below Questions

What could be a data source system?

579


what is 'reconsideration error' and how can i respond to this error and how to debug this

2121


What are the steps required to kill the job in Datastage?

686


On which interface you will be working as a developer?

639


describe the Steps to confiure a Qlogic switch

1939






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?

1758


What can we do with datastage director?

675


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2082


Can you filter data in hashed file?

3347


What is orabulk stage?

636


What are the components of datastage?

656


root tree will find which is server job and which is parallel job?

1455


how to export or import the jobs in .ISX file

721


How do you reject records in a transformer?

629


CHANGE CAPTURE

896