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
- 19570 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / mitesh gaur
I think there is no need of using any aggregation. It's very
straight fwd, just sort the data on date and fetch only
first record.
Add the below query to source qualifier's SQL OVERRIDE
and that will be your result - (lets say table name is TmpTab)
select * from (select * from TmpTab order by date) where
rownum = 1;
now connect id, date to target.
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Can you use flat files in Mapplets.
How do you remove duplicate records in informatica? And how many ways are there to do it?
How might one distinguish in the case of mapping is right or not without associating session?
In which transformation you cannot drag ports into it?
Is there any target staging area in informatica not staging area
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to improve the performance of a session using sorter transformation?
What is informatica powercenter repository?
How is union transformation utilized?
What is aggregate cache in aggregator transformation?
What are the features of complex mapping?
how tokens will generate?
Define filter transformation?
what is informatica metadata?
