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 / bidhar
I think you can get this by SQ Override query itself.
SQ->Exp->Target
SQ Override Query:
SELECT ID,MIN(DATE) FROM TABLENAME GROUP BY ID.
Let me know if i am wrong.
Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are roles and groups and benefits of using them?
Explain the different dimensions.
What is exclusive and normal mode for repository services?
Write the different tools in the workflow manager?
How to load data in informatica ?
What are the main issues while working with flat files as source and as targets ?
Target increases every day even though no new record was inserted
Define pmcmd command?
Design time, run time. If you don't create parameter what will happen
generate date / time dimension in informatica
Why union transformation is an active transformation?
Reusable transformation and shortcut differences
How to convert multiple rows to single row (multiple columns) in informatica
What is informatica worklet?
How do you load first and last records into target table?