Answer / 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.

Answer / chandra swain

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......

Answer / shar

whats wrong with the people
see we have 3 targets so.,.
use below under tx constraints
mod(src,3)=1 move it to target1
mod(src,3)=2 move it to target2
mod(src,3)=0 move it to target3

seq-->tx-->dataset(3)
whats the big deal in it?

Answer / bharath

If src have n no. of records then how will u do the same?

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

Answer / 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.

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

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

What is the use of datastage designer?

0 Answers  

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

What is the difference between account and directory options ?

0 Answers  

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?

8 Answers   Cognizant, HCL, TIAA CREF,

How can we do null handling in sequential files?

3 Answers   Reliance,

What is PX?

2 Answers   IBM,

How can you write parallel routines in datastage PX?

0 Answers  

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 Answers  

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

State the difference between an operational datastage and a data warehouse?

0 Answers