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
- 15600 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 a shortcut and copy in Informatica and how two are different with each other?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Please let me know how to make encryption and decryption with example?
In how many ways we can create ports?
Why is sorter an active transformation?
What are the differences between source qualifier and joiner transformation?
What are 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 to load dimension table and fact table. plz tell me the steps.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Repository user profiles
How might you approve all mappings in the archive all the while?
Global and Local shortcuts. Advantages.
What are the main features of Oracle 8i with context to datawarehouse?
Differences between connected and unconnected lookup?
What are the different types of repositories created using informatica?
