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.
Answers were Sorted based on User's Feedback
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 |
source-->transformersatage--->dataset1
---->dataset2
----->dataset3
double click on transformerstage,copy the input to output link
i.e(dataset1,dataset2,dataset3),then go to constraint part of the transformer stage ,we will find three constraint tabs,
in 1st constraints tabs write down--> column=1orcolumn=2orcolumn=3orcolumn=10orcolumn=11orcolumn=12
then go to 2nd constraints tabs --->write similarly
column=4orcolumn=5orcolumn=6orcolumn=13orcolumn=14orcolumn=15
,then go to 3rd constraints tab and click on otherwise/Log
go to dataset1,click on partitioning tab,select partition type:=hash,then click on check box(i.e perform sort)..
similarly ,go to dataset2,dataset3,and mention all the above technic...
i hope u got solun......
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / kumar
source seq file is connected to transformer stage and take
three out links connected to three data sets
in transformer stage under constraints by using Mod
Function we can acheive the result for N number of records
| Is This Answer Correct ? | 2 Yes | 1 No |
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 |
Answer / dinesh
Find MOD9 based on input data say we call as MOD
constraint in transformer
Target 1 - MOD IN 1,2,3
Target 2 - MOD IN 4,5,6
Target 3 - MOD in 7,8,0
| Is This Answer Correct ? | 0 Yes | 0 No |
Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
Describe routines in datastage? Enlist various types of routines.
Can you explain link buffering?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?
i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?
how many rows sorted in sort stage by default in server jobs
what about data stage requirement
What are the steps required to kill the job in Datastage?
what is executable in DataStage?
i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
How do u convert the columns to rows in datastage?