Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 7 Answers
- 10597 Views
- I also Faced
- E-Mail Answers
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 is difference between join, merge and lookup stage?
EXPLAIN SCD
How a source file is populated?
What is the purpose of pivot stage?
What are the difference types of stages?
What are the types of containers?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What are the different plug-ins stages used in your projects?
how can we create rank using datastage?what is the meaning of rank?
What all are the different way to run a job?
What is ds designer?
How to manage date conversion in Datastage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Differentiate between validated and Compiled in the Datastage?
What are the components of ascential data stage?
