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 / 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 |
Post New Answer View All Answers
lookup transformation with screenshots
What is a sequence generator transformation?
What is the scenario which compels informatica server to reject files?
what is degenerated dimension?
How to use pmcmd utility command?
What are the different types of transformation available in informatica.
What are the databases that informatica can connect to windows?
How can we delete duplicate rows from flat files?
Is it possible to revert a global repository to local one and why?
Where is metadata stored?
While migrating the data from one environment to another environment how would you manage the connections?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Global and Local shortcuts. Advantages.
How to improve the performance of a session using sorter transformation?
What is a filter transformation?