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
- 10340 Views
- I also Faced
- E-Mail Answers
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 |
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
In one project how many shared containers are created?
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
How we can convert rows to columns in datastage?
How can you join flat file, oracle as a sources?
What is the difference between orabulk and bcp stages?
Hi This is Vijay How Can u Read the data from sequential file Parall'y?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is active and passive stage?
How a routine is called in datastage job?
what is the exact difference between dataset and fileset in datastage?
Teradata 
