my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?

Question Posted / vkrish

10 Answers
16932 Views
Polaris, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / vamsi

hi,
srikanth

it 's not possible by using round robin , round robin can send recordes to nodes not to target..

if we can use collection methodes also we have 3 targets ,it's not possible

Is This Answer Correct ?

11 Yes

3 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / venkatesh

the flow is like this

source---->transformer-------->t1
----------->t2
-------------->t3
------------------>t4
in transformer create a stage variable to calculate mod value

mod(input,4) | mod_value
_________________|____________

in constrain write the condition as

mod_value =1 for t1
mod_value=2 for t2
mod_value=3 for t3
mod_value=0 for t4

try this u will get the required o/p

Is This Answer Correct ?

7 Yes

0 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / abd

We can use stage variable in Tran Stage

IF @INROWNUM MOD 4 = 0 then T4
Else If @INROWNUM MOD 4 = 1 then T1
Else If @INROWNUM MOD 4 = 2 then T2
Else If @INROWNUM MOD 4 = 3 then T3

Try this

Is This Answer Correct ?

7 Yes

2 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / srikanth

hi
it is possible by using transform stage
select the function in that select the mathematical in that
select the mod function and run the job

you will get the answer

Thanks & regards
srikanth.k
9573056597

Is This Answer Correct ?

3 Yes

3 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / vamsi

hi.,
srikanth

can u plz explain in detail...........

Is This Answer Correct ?

0 Yes

0 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / jyothi

how this scenario without using MOD operator
if any body know plzzzz tel me...

Is This Answer Correct ?

0 Yes

0 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / bharath

It worked out for round robin also.. plz try..

Is This Answer Correct ?

1 Yes

3 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / bharath

Hi,

try this,

take two sequntial files, one as source and another as target
as follows

src_seq------------------->tgt_seq

in target give 4 target *.txt files.
give partition type as modulus or roundrobin..
try this...

Is This Answer Correct ?

1 Yes

3 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / varaprasad

as for as i know,it is simple task only,
order is seq_file->column_generator->tfx->connect 4 targets.
in CG take one more column as SNO(anything)and goto extended column properties- take value=1,value=2,,,upto 4. now write constraint in tfx sno=1 goto t1
sno=2 goto t2...for all targets(4).

if u get other tahn this pls post answer

Is This Answer Correct ?

3 Yes

6 No

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 ..

Answer / srikanth

it's a very simple task
select the partition type as round robin
and run the job
you will get the answer

thanks& regards
srikanth
9573056597

Is This Answer Correct ?

5 Yes

11 No

Post New Answer