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 / subhash
I hope this will help you:
--------->T1
|
|
source---->transformer---------- -------->T2
|
|
--------->T3
Transformer:
1.drag source column to all the targets.
2.TARGET T1 constraint in Transformer:
Mod(input column, 9)=1 or Mod(input column, 9)=2 or Mod
(input column, 9)=3.
3.TARGET T2 constraint in Transformer:
Mod(input column, 9)=4 or Mod(input column, 9)=5 or Mod
(input column, 9)=6.
4.TARGET T3 constraint in Transformer:
Mod(input column, 9)=7 or Mod(input column, 9)=8 or Mod
(input column, 9)=0.
Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are routines in datastage?
What is job control?
What is the precedence of stage variables,derivations, and constraints?
What are the functionalities of link partitioner and link collector?
Enlist various types of routines in datastage.
how to sort two columns in single job in datastage.
What are the features of datastage flow designer?
What could be a data source system?
What are stage variables, derivations and constants?
How to convert RGB Value to Hexadecimal values in datastage?
Name the third party tools that can be used in datastage?
What is a datastage job?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is datastage engine?
What steps should be taken to improve Datastage jobs?