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
- 10540 Views
- I also Faced
- E-Mail Answers
Answer Posted / pranay
source----->transformer----->filter------>T1
|
|
--------->T2
|
|
--------->T3
Transformer:
1.drag source column to target.
2.append new column in transformer target as new and apply derivation Mod(input column, 3).
Filter:
where condition1 new = 1
condition2 new = 2
condition3 new = 0
Name the three targets T1, T2, T3.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
which r the connectors used in san?
How to read the length of word in unix?
Have you used Unstructured data?
What is the use of datastage designer?
Why fact table is in normal form?
Why do you need stage variables?
What is the difference between account and directory options ?
What are the different type of jobs in datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
whom do you report?
How to convert RGB Value to Hexadecimal values in datastage?
Explain the importance of surrogate key in data warehousing?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What are stage variables and constants?
What are transforms and what is the differenece between routines and transforms?
