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
- 18988 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
What is repository manager?
Does an informatica transformation support only aggregate expressions?
Write the unconnected lookup syntax and how to return more than one column.
What are the modules in Power Center
How to join three sources using joiner?
What are the differences between oltp and olap?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the prerequisite tasks to achieve the session partition?
Parameter and variable differences
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the status code in stored procedure transformation?
What all are steps in up gradation of Informatica server?
Do you find any difficulty while working with flat files as source and target?
What is different between the data warehouse and data mart?
server hot-ws270 is connect to Repository B. What does it mean?
