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
- 10323 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
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is the use of datastage designer?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the difference between validated and compiled in the datastage?
Give an idea of system variables.
What are the functionalities of link collector?
What steps should be taken to improve Datastage jobs?
how to sort two columns in single job in datastage.
How do you import and export data into datastage?
How do you import and export the datastage jobs?
Explain Quality stage?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Which commands are used to import and export the datastage jobs?
How many types of sorting methods are available in datastage?
What are orabulk and bcp stages?
