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
- 8952 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
What is meant by incremental aggregation?
r u done any partitions in ur project?
Enlist the tasks for which source qualifier transformation is used.
What are the uses of etl tools?
How to use pmcmd utility command?
What are the types of schemas we have in data warehouse.
How many ways a relational source definition can be updated and what are they?
What are active and passive transformations?
What is Index Caches size?
What are the restrictions of union transformation?
What are the types of lookup transformation?
What is aggregate cache in aggregator transformation?
how tokens will generate?
What is dynamic cache?
How to Create a folder using pmrep command?
