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
- 10505 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 the flow of loading data into fact & dimensional tables?
Define Routines and their types?
sed,awk,head
Enlist various types of routines in datastage.
Triggers,VIEW,Procedures
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
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is job control?
what is flow of project?
Can you explain kafka connector?
Can you filter data in hashed file?
Terminate Activity
What are the functionalities of link partitioner and link collector?
How to reverse the string using unix?
How to read multiple files using a single datastage job if files have the same metadata?
