i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
Answer Posted / rakesh
use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Define pmcmd command?
What are the different options available for update strategy?
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
What is the cumulative sum and moving sum?
What is the difference between router and filter?
What are the types of caches in lookup?
What is meant by query override?
What are the different types of repositories created using informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is InformaticaPowerCenter?
How is union transformation utilized?
What are the different types of olap? Give an example?
Partition, what happens if the specified key range is shorter and longer