Use aggregator transformation and check group by for ID Column and use max

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG
I need to get max date and its corresponding flag for both the date columns.

Ex:-
1A,10/3/2015,AC,10/3/2015,XY
1A,10/4/2015,AB,10/2/2015,XZ

Output needed
1A,10/4/2015,10/3/2015,XY

I have 100 million + in the table so avoid self-join...

Question Posted / kiran

2 Answers
4468 Views
Amex, I also Faced
E-Mail Answers

Answer Posted / kiran

Use aggregator transformation and check group by for ID Column and use max function for both the dates.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1920

Clarify the aggregator change?

1029

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2169

Explain direct and indirect flat file loading (source file type) - informatica

1318

Explain the aggregator transformation?

1165

how to create user defined function (udf) in informatica

1307

Explain the scenario which compels informatica server to reject files?

1168

Different qualification between a related rotate toward the sky and isolates look upward?

986

explan ur project architecture?

2069

What do you mean by worklet?

1064

What are the limitations of joiner transformation?

1114

Plz can any one say me how to get the informatica certification materials and dumps

2048

scenario where i can use only concurrent execution of workflow.

3172

What is substr in informatica?

1208

Quickly characterize reusable change?

1119