I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target?

I am new to Informatica,can anybody suggest me the idea?

Question Posted / shiva55

2 Answers
3543 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in..

Answer / sajid hussain

Step1: After SQ transformation take Sequence Generator transformation and edit properties like, Start Value=1, Increment By=1, End Value=3 and check the Cycle.

Step2: Now take a Router transformation and drag all the ports from SQ transformation to Router, as well as drag the NEXT VAL port from Sequence Generator transformation to Router.

Step3: Create 3 group T1, T2 and T3 and for each group condition will be like T1 --> NEXTVAL=1, T2 --> NEXTVAL=2 and T3 --> NEXTVAL=3

Step4: Connect all the 3 targets and run the mapping.

Is This Answer Correct ?

1 Yes

1 No

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in..

Answer / naveenkumar

drag and drop the source to the mapping and connect the expression transformation.variable port to an expression transformation
v_count=v_count+1
o_count=v_count
and exp transformation to connect the router transformation groups
column name<=25 lks
column name>=26 lks and column name<=50 lks
column name>=51 lks and column name<=75 lks
column name>=76 lks and column name <=1 cros

Is This Answer Correct ?

0 Yes

0 No

Post New Answer