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
What could be a data source system?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the steps required to kill the job in Datastage?
On which interface you will be working as a developer?
describe the Steps to confiure a Qlogic switch
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 can we do with datastage director?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Can you filter data in hashed file?
What is orabulk stage?
What are the components of datastage?
root tree will find which is server job and which is parallel job?
how to export or import the jobs in .ISX file
How do you reject records in a transformer?
CHANGE CAPTURE