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
- 9062 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
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is an expression transformation in informatica?
Explain what is informatica metadata and where is it stored?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the difference between source qualifier transformations source filter to filter transformation?
what is unit testing?tell me proceedure
What are the prerequisite tasks to achieve the session partition?
Briefly define reusable transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
What is complex mapping?
What is meant by lookup transformation? Explain the types of lookup transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What do you mean by enterprise data warehousing?
What are active and passive transformations?
