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
- 10341 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
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Differentiate between data file and descriptor file?
What are the stages in datastage?
Where do you see different stages in the designer?
Describe link sort?
How to clean the datastage repository?
Difference between in process and inter process?
how to implement scd2 in datastage 7.5 with lookup stage
Which warehouse using in your datawarehouse
What are stage variables, derivations and constants?
Explain ibm infosphere information server and highlight its main features?
what is ds administrator used for?
On which interface you will be working as a developer?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is the difference between the local container and shared container?
