Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9101 Views
- Satyam, I also Faced
- E-Mail Answers
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
what is size of u r database?
What are the types of presistent cache in look up tr.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is meant by active and passive transformation?
What is the cumulative sum and moving sum?
What is blocking transformation?
Which are the different editions of informatica powercenter that are available?
What is the way to execute pl/sql script using informatica mapping?
What is a predefined event?
Explain the tuning lookup transformation - informatica
Where is metadata stored?
What is rank transformation?
Repository user profiles
What is repository manager?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
