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
- 15023 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
Can we get 1st record through Informatica(without sequence number).
Can we create a Integration service without a Repository service and vice versa?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is the session task and command task?
Explain the pipeline partition with real time example?
Did u used latest transformations of 8.6.0? for what?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is workflow manager?
how many types of dimensions are available in informatica?
What is lookup change?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Design a mapping to load a target table with the following values from the above source?
What is the maplet?
