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
- 15317 Views
- Cap Gemini, CTS, I also Faced
- E-Mail Answers
Answer Posted / sudha
Src->sq->seq_gen->exp->agg->flt->tgt
create new port as M_PORT in Exp and leave empty.
write a logic in AGGR for M_PORT as MAX(SEQ_PORT)
Write a logic in FLTR as "SEQ_PORT!=1 AND SEQ_PORT!=m_port"
Please correct me if am wrong.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is lookup change?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the mapping parameters and mapping variables?
expain about the tune parameters?
What is the sequence generator transformation in informatica?
What is informatica worklet?
What is session task and command task?
Can you generate sequence numbers without using the sequence generator transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How does a sorter cache works?
How would you join a node to the already existing domain?
How to update source definition?
How to generate sequence numbers without using the sequence generator transformation?
