Interested to Buy Any Domain ? << Click Here >> for more details...
How to create a mapping ?
id date
101 2/4/2008
101 4/4/2008
102 6/4/2008
102 4/4/2008
103 4/4/2008
104 8/4/2008
O/P - shud have only one id with the min(date)
How to create a mapping for this
- 9 Answers
- 19566 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / azhar
Simple use sql override query:
select top1 * from TABLENAME order by ID,DATE
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to elaborate powercenter integration service?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Is there any way to read the ms excel datas directly into informatica?
What are active and passive transformations?
How to Create a folder using pmrep command?
What are Dimensional table?
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the new features of informatica 9.x developer?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How many ways are there to create ports?
Reusable transformation and shortcut differences
Explain the difference between a data warehouse and a data mart?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What you know about transaction control transformation?
Explain constraint based loading in informatica
