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?
Answer Posted / 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 View All Answers
What are the differences between a connected lookup and unconnected lookup?
How can we update a record in the target table without using update strategy?
What are data-driven sessions?
EXL informatica Questions
What all join we can perform in LOOKUP transformation?
What are the differences between joiner transformation and source qualifier transformation?
What is depict expression change?
Separate from a database, an information bazaar, and an information stockroom?
What is a pre-defined event and user-defined event?
Differentiate between reusable transformation and mapplet.
What do think which one is the better joiner or look up?
How to start a workflow using pmcmd command?
difference between repository database and repository service?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the difference between informatics 7x and 8x and what is latest version?