Table has this value:

need below output:

CodePudding user response：

You can group by extracted date value, so need a conversion such as the one below

SELECT heading1, MAX(heading2)
  FROM t
 GROUP BY heading1, TRUNC(heading2)

the above SELECT statement is based on the Oracle database, you can replace TRUNC(heading2) depending on your current DBMS. The data type of heading2 is presumed to be TIMESTAMP

CodePudding user response：

informatica only solution -

1. Create an exp transformation with three ports.

in_out_Heading1
in_out_Heading2
out_date_trunc=TRUNC(in_out_Heading2)

2. Next, use an agg transformation with below ports.

in_out_Heading1  --group by port
in_Heading2
in_date_trunc --group by port
out_Heading2=MAX(in_Heading2)

And then connect out_Heading2 and in_out_Heading1 to your final target.