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
- 8150 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 event and what are the tasks related to it?
What is mapping debugger?
Define pmcmd command?
I have a flat file, want to reverse the contents of the flat file
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Write the unconnected lookup syntax and how to return more than one column.
Can we create a node as a gateway node and the same node can be assigned to a grid?
Scheduling properties,whats the default (sequential)
COM components can be used in Informatica
Briefly describe lookup transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are the tasks that can be performed using sq?
How identifying bottlenecks in various components of informatica and resolving them?
What is an Integration service in Informatica?
What does role playing dimension mean?
