i have thousand records in my source(flat file) i wanna load 990 records i don&

i have thousand records in my source(flat file) i wanna load
990 records i don't want load first 5 records and last 5
records at informatica level?

Question Posted / ravishankar

3 Answers
7836 Views
Satyam, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

i have thousand records in my source(flat file) i wanna load 990 records i don't want load fir..

Answer / sehaj

PASS RECORDS FROM SOURCE QUALIFIER TO EXPRESSION.
CREATE A VARIABLE WITHA GGREGATION AS COUNT N ASSIGN ITS VALUE AS 0.
CREATE TWO PARAMETRES N ASSIGN DEM VALUES.
FIRST ONE 5
SECOND ONE 995
.
IN EXPRESSION CREATE AN OUTPUT PORT AS NUMBER DATATYPE N IN THE EXPRESSION EDITOR WRITE....
SEQUENCE=SETCOUNTVARIABLE(VARIABLE NAME U CREATED).

NOW
ATTACH IT TO THE ROUTER
CREATE A GROUP AND ENTER CONDITION
SEQUENCE>5 AND SEQUENCE<995
CONNECT THIS PORT TO TARGET...

SEHAJ....

Is This Answer Correct ?

10 Yes

0 No

i have thousand records in my source(flat file) i wanna load 990 records i don't want load fir..

Answer / lakshmi

source--->source qualifier--->sequencegenerator--->
exp--->router--->target.

Take nextval port and assign to exp

In router write condition below as
nextval>=5 and nextval<=995

copy all the ports from router to target

Is This Answer Correct ?

8 Yes

0 No

i have thousand records in my source(flat file) i wanna load 990 records i don't want load fir..

Answer / swathi

SOURCE->SQ->EXP->ROUTER->TARGET
After sq take seq or exp in exp using variable port concept create seq id like
v_count=count+1;
create output port assign variable port to output like
o_count=v_count
next take router and pass output port to router give condition
o_count>=5 and o_count<=985

Is This Answer Correct ?

1 Yes

0 No

Post New Answer