hi this is kiran i have one table i want divide the table with two different t

hi this is kiran
i have one table i want divide the table with two different
table like even rows and odd rows
how can i do this one
tell me plzz

Question Posted / vmkiran88

4 Answers
9003 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

hi this is kiran i have one table i want divide the table with two different table like even rows ..

Answer / eswar

oracle stage--->surrogate key generator--->transformer

the t/f having 'mod' function

mod(empkey,2)=0 --->even rows
mod(empkey,2)<>0 --->odd rows

empkey is generated from surrogate key generator

Is This Answer Correct ?

3 Yes

0 No

hi this is kiran i have one table i want divide the table with two different table like even rows ..

Answer / farzana kalluri

Hi we can achive like this

Source--->Transformer---->filter--->2 targets

Transformer--->1.constraints--->mod(input,2)=0

2.constraint---->mod(input,2)=1
From this we can get the odd numbers in one target and
even numbers in one target...

Is This Answer Correct ?

2 Yes

0 No

hi this is kiran i have one table i want divide the table with two different table like even rows ..

Answer / srinu

sourc->transformer->filter->two targets
in the transformer stage we have append new column and
derviation area write mod(@outrownum,2) (where @outrownum in
sysvarible)
after that we put fileter or switch in that
write condition on append column 0 then even records
1 then go odd records

Is This Answer Correct ?

1 Yes

0 No

hi this is kiran i have one table i want divide the table with two different table like even rows ..

Answer / nish

You could also go for a column generator and cycle the values 1,0.
then filter based on this column.

It will be much faster then employing a transformer stage having to generate @rownum and then do a mod calculation.

Trying to reduce the number of transformer stages is a key efficiency best practice.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer