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
- 18991 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / rob
Add the below query to source qualifier's SQL OVERRIDE
and you will get the required output
select * from (select min(to_date(date,'dd/mm/yyyy'))as
d,id from emp
group by id order by d)where rownum =1;
source-->SQualifier(with query)----> target
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain sessions?
What do mean by local and global repository?
How will the document be delivered to me?
What are the main issues while working with flat files as source and as targets ?
How can you differentiate between powercenter and power map?
What is a surrogate key?
What is joiner transformation in informatica?
How to generate sequence numbers?
What can we do to improve the performance of informatica aggregator transformation?
difference between informatica 8.1.1 and 8.6
What is persistent lookup cache?
What are multi-group transformations?
Have you worked with/created Parameter file
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?
On which transformations you created partitions in your project?
