i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100
i want target like
target1
deptno,sal
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100
with out using transformerstage
Answer Posted / rafi
by using round robin partition with two nodes we can get the solution.
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What are some different alternative commands associated with "dsjob"?
What is the differentiate between data file and descriptor file?
What is a quality stage in datastage tool?
Explain the situation where you have applied SCD in your project?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between an operational datastage and a data warehouse?
AGGREGATOR default datatype
what is the use of skid in reporting?
What is ibm datastage flow designer?
what are the devoleper roles in real time? plz tell i am new to datastage....
How do you register plug-ins?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
What is the difference between account and directory options ?
How a server job can be converted to a parallel job?