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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what is song in infrmatica...?
How to improve the performance of a session using sorter transformation?
Explain joiner transformation in informatica
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Under which circumstances, informatica server creates reject files?
What is pmcmd command?
without table how to come first record only in oracle?
How do you change a non-reusable transformation to reusable transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
what is diff b/t sorter t/r and agg have the option sorter property...
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Explain dynamic target flat file name generation in informatica
What is incremental aggregation?