Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 9962 Views
- I also Faced
- E-Mail Answers
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 can you write parallel routines in datastage PX?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
If you want to use a same piece of code in different jobs, how will you achieve this?
How to clean the datastage repository?
Can you highlight the main features of ibm infosphere information server?
options available in sequence job to run,validate?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
what is the custome stage in datastage? how can we impliment that one? plz tell me
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are constraints and derivations?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
