I think its Simple, with Agg Transformation,
First  Group by ID,
Then go  with min (date)  in same Agg Transformation.

I think its Help you,,,,,,
Any ???  r Corrections,,,Let me know  
srinu.srinuvas@gmail.com

Hi Achoudhr,

here u go,

sq--->agg----->target

In agg dont use group by on any port and take output 
columns for both id & date ports, use 'min' function in 
outpput expression and connect output ports to desired 
target columns.you will get only one output row that is 101 
2/4/2008.

note: if u use group by mapping outputs 3 rows.

I guess the below logic will solve this question.. 

Sq -> Expression T/R -> Aggr t/r -> Target

Create a constant port in Expression t/r and then pass the 3
fields id, date & const port to the aggregate t/r... Create
a new port calculating mindate.. Now do a group by on the
Const field ; connect id & min Date fields to the Target...

FYI, If u don't apply group by on any column of the table ;
can not calculate the Aggr values...

Please correct me if I am wrong...

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.