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 |
How we can covert server job to a parallel job?
What is difference between join, merge and lookup stage?
Describe link sort?
how to transfer file from one system to another system in unix? which cmd to be use?
source contains 2 columns comes to target 4 columns how
How you Implemented SCD Type 1 & Type 2 in your project?
Which type of joins Merge stage can support?
Thanks to all people who are posting their comments...
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
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
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name