Interested to Buy Any Domain ? << Click Here >> for more details...
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
- 6 Answers
- 15025 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
Answer Posted / kuldeep singh rathore
Src->sq->seq_gen->exp\_joiner->flt->tgt
---------->agg/
create a new port for count in agg and one dual port we assign 1 in that
and in exp also we add a port dual =1
we give condition in joiner on dual port
Write a logic in FLTR as "SEQ_PORT!=1 AND (count-SEQ_PORT)!=0"
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does command task mean?
can anyone suggest best free Talend data integration training online
Suppose we do not group by on any ports of the aggregator what will be the output?
How many ways are there to do 'remove duplicate records in informatica'?
What are the different versions of informatica?
How to create or import flat file definition in to the warehouse designer?
What is sorter transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Briefly describe lookup transformation?
What is workflow monitor?
what is index?how it can work in informatica
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Is stop and abort are same in informatica?
What is data movement mode in Informatica and difference between them?
What is Session and Batches?
