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
- 15048 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 incremental aggregation?
What is a passive transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Differences between connected and unconnected lookup?
What is a mapplet/worklet in informatica?
What is the maplet?
How many input parameters can exist in an unconnected lookup?
What is Session and Batches?
How can we use mapping variables in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Could you explain what is enterprise data warehouse?
What is meant by query override?
How to use pmcmd utility command?
