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?
- 3 Answers
- 7826 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Normalizer transformation is not involved in Mapplet.. why???
How to eliminate duplicates in FF and oracle both
whether Sequence generater T/r uses Caches? then what type of Cache it is
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
What is tracing level and what are the types of tracing level?
version controlling in informatica?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
why normalizer transformation can not used in mapplet? plzzzz answer
can you use flat file for repository?why?
without using emailtask how will send a mail from informatica?
What is the difference between stop and abort in informatica
write a query to retrieve the latest records from the table sorted by version(scd)
Teradata 
