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
Enlist the advantages of informatica.
What is the need of an ETL tool?
How to load data in informatica ?
Did u used latest transformations of 8.6.0? for what?
Enlist some properties of sessions.
What are the components of workflow manager?
Differentiate between Load Manager and DTM?
In which transformation you cannot drag ports into it?
What is intricate mapping?
Differences between connected and unconnected lookup?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
How to do unit testing in informatica? How to load data in informatica ?
What are the different components of powercenter?
permutations of mapplet
What is the sql query overwrite in source qualifier in informatica