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
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
What is status code in informatica?
What do you mean by filter transformation?
How to configure mapping in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are the restrictions of union transformation?
Enlist the tasks for which source qualifier transformation is used.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Design time, run time. If you don't create parameter what will happen
COM components can be used in Informatica
What are the features of complex mapping?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can we override a native sql query within informatica?
What are the different options available for update strategy?
What is Session and Batches?
what is unit testing?tell me proceedure