Source flat file contains
src
---
1
2
'
'
'
18
we had 3 targets
T1 T2 T3
-- -- --
1 4 7
2 5 8
3 6 9
10 13 16
11 14 17
12 15 18
How can i get?
**Using only datastage, but not unix or any other.
I am expecting the answer soon..
Thanks in advance.
Answer Posted / shar
whats wrong with the people
see we have 3 targets so.,.
use below under tx constraints
mod(src,3)=1 move it to target1
mod(src,3)=2 move it to target2
mod(src,3)=0 move it to target3
seq-->tx-->dataset(3)
whats the big deal in it?
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which commands are used to import and export the datastage jobs?
What is the command line function to import and export the ds jobs?
Differentiate between Join, Merge and Lookup stage?
What is the use of datastage director?
What is merge stage?
What is the difference between an operational datastage and a data warehouse?
What is data partitioning?
What are the some differences between 7.x and 8.x version of datastage?
What are the components of datastage?
What are the functionalities of link partitioner and link collector?
What is the difference between datastage and datastage tx?
Is the value of staging variable stored temporarily or permanently?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
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?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4