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
- 15374 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
How do we call shell scripts from informatica?
Separate from an archive server and a powerhouse?
How are indexes created after completing the load process?
What are mapplets? How is it different from a Reusable Transformation?
What is the format of informatica objects in a repository?
What are the data movement modes in informatica?
How would you join a node to the already existing domain?
Design time, run time. If you don't create parameter what will happen
Differentiate between a repository server and a powerhouse?
How to convert multiple rows to single row (multiple columns) in informatica
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is a sorter transformation?
What is the surrogate key?
What can we do to improve the performance of informatica aggregator transformation?
