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
- 9217 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 the use of an aggregator cache file?
Different qualification between a related rotate toward the sky and isolates look upward?
Sequence generator, when you move from develoment to production how will you reset
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is meant by query override?
What is data transformation manager process?
What do you understand by term role-playing dimension?
What is the sequence generator transformation in informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Did u used latest transformations of 8.6.0? for what?
What is rank transformation in informatica
How would you join a node to the already existing domain?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain the scenario which compels informatica server to reject files?
