I think you can get this by SQ Override query itself. SQ->Exp->Tar

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

Question Posted / bidhar

9 Answers
19572 Views
Deloitte, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

can you please explain me pre session and post session options?

7678

What is InformaticaPowerCenter?

1179

What is the difference between router and filter?

1376

How to go to the older version for a mapping?

1159

What are the differences between joiner transformation and source qualifier transformation?

1238

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1124

How to generate sequence numbers without using the sequence generator transformation?

1265

What is the reusable transformation?

1103

What is a code page?

1220

What is a filter transformation and why it is an active one?

1016

Explain incremental aggregation in informatica

1185

What are the issues you have faced in your project? How did you overcome those issues?

2413

What if the source is a flat-file?

1170

What is mapping debugger?

1069

generate date / time dimension in informatica

1164