i have a source with 100 records.i have 2 targets.in the first target i want t

i have a source with 100 records.i have 2 targets.in the first
target i want to load first 50 records & in the second target
i want to load next 50(or remaining) records.

Question Posted / lavi

3 Answers
7675 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 reco..

Answer / mukunda

Mapping structure
=================

source-->sq-->sequence-->exp-->router-->target1
|-->target2

1)Pass the seq genarator "nextval" port to expression.
2)through expression t/r pass the variable port to router
3)In router create two groups

Group1:nexval<=50-->this group conneted to target1
Groutp2:nexval>=50-->this group conneted to target2

or

default group connected to target2

Note: This logic only that source data contain 100 records.

If you any quires please ask.

Best Regards,

Mukunda
mukunda.velluri@gmail.com

Is This Answer Correct ?

6 Yes

0 No

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 reco..

Answer / balakrushna

Hi Mukunda,
U r correct but, y u are using addional t/r Exp, without
EXP we will make this mapping scenario,

I made it actually, that is the way i am sending this
like as follow

SQ-Gen-|
|
Source--> SQL------>RTR->Target1
|
|--->Target2

In SQ-Gen:
Change the Startvalue, Endvalue and Check the CYCLE and
RESET option in the properties of SQ-Gen
popuklate the NEXTVAL from Seq_gen to RTR.

In the RTR t/r:
(as my scnario the 3 records will load tgt1 and next 3 will
load in tgt2 and next 3 will load in again TGT1 and so on..)
2 groups
one is NEXTVAL <= 3
and NEXTVAL >= 4
and populated these groups to ur target accordingly.

Thanks & Regards
Balakrushna

Is This Answer Correct ?

2 Yes

0 No

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 reco..

Answer / kamleshmishra291

After SQ take expression and add port
v_Sequene=v_Sequence+1
o_Sequence=v_Sequence
Take Router Transformation and add two groups
Group1 = o_sequence<=50
Group2=o_sequence>50
Connect Group1 and Group2 to Target1 and Target2

Is This Answer Correct ?

0 Yes

0 No

Post New Answer