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
- 15342 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
Have you worked with/created Parameter file
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
can u any challenge your project?
What is update strategy transform?
What is union transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a stored procedure transformation?
How to call shell scripts from informatica?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the difference between a connected look up and unconnected lookup?
Define mapplet?
What is depict expression change?
In informatica workflow manager, how many repositories can be created?
Target increases every day even though no new record was inserted
Reusable transformation and shortcut differences
