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 / dinesh
Find MOD9 based on input data say we call as MOD
constraint in transformer
Target 1 - MOD IN 1,2,3
Target 2 - MOD IN 4,5,6
Target 3 - MOD in 7,8,0
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How can you write parallel routines in datastage PX?
What are the primary usages of datastage tool?
What are routines in datastage? Enlist various types of routines.
What is the purpose of pivot stage?
Why do we use link partitioner and link collector in datastage?
What are the partitioning techniques available in link partitioner?
What is the difference between in process and inter process?
What are some prerequisites for datastage?
Differentiate between hash file and sequential file?
What is ibm datastage flow designer?
What is quality stage?
Can you implement SCD2 using join, transformer and funnel stage?
options available in sequence job to run,validate?
What are the components of ascential data stage?