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
- 6606 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
What are stage variables?
What a datastage macro?
Differentiate between validated and Compiled in the Datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
What is a folder? Difference types of stages?
What is difference between symmetric multiprocessing and massive parallel processing?
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 is data partitioning?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Define ds designer?
how can we create rank using datastage?what is the meaning of rank?
What are the different type of jobs in datastage?
