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
- 9235 Views
- Satyam, I also Faced
- E-Mail Answers
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
How to create the source and target database connections in server manager?
Explain lookup transformation source types in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the databases that informatica can connect to windows?
What are the new features of informatica 9.x developer?
Briefly describe lookup transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is a transaction control transformation?
How to use procedural logic inside infromatica?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What do you mean by filter transformation?
How can we handle two sessions in informatica?
Explain the use of aggregator cache file?
