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
18990 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

What is dynamic cache?

973

What are the components of the workflow manager?

1083

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1933

How to use pmcmd utility command?

972

Write the program through which the records can be updated?

938

Which are the different editions of informatica powercenter that are available?

971

Explain incremental aggregation in informatica

1069

update strategy transformation in informatica

1017

What is meant by LDAP users?

1114

Explain pushdown optimization and types in informatica

1018

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1987

Design time, run time. If you don't create parameter what will happen

1797

What is mapplet in informatica?

983

What is rank transformation in informatica

1113

How can a transformation be made reusable?

1079