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 is INFORMATICA TESTING process
What are the informatica performance improvement tips
What is the use of an aggregator cache file?
What do you understand by term role-playing dimension?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is the meaning of up gradation of repository?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain lookup transformation source types in informatica
Which version configuration tool used in ur project?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
what is degenerated dimension?
What is depict expression change?
Which transformation should we use to normalise the COBOL and relational sources?
What is xml source qualifier transformation in informatica?