Answer / srinu

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

Answer / dl

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.

Answer / mitesh gaur

I think there is no need of using any aggregation. It's very
straight fwd, just sort the data on date and fetch only
first record.
Add the below query to source qualifier's SQL OVERRIDE
and that will be your result - (lets say table name is TmpTab)

select * from (select * from TmpTab order by date) where
rownum = 1;

now connect id, date to target.

Answer / rob

Add the below query to source qualifier's SQL OVERRIDE
and you will get the required output

select * from (select min(to_date(date,'dd/mm/yyyy'))as
d,id from emp
group by id order by d)where rownum =1;

source-->SQualifier(with query)----> target

Answer / parthiban

S->SQ->SRT->EXP->FIL->TGT

Sort on date Column

In Expression, Create variable ports for partition
V_Currdate = date
V_Flag = IIF(V_Currdate = V_Prevdate, V_Flag+1,1)
V_Prevdate =date
O_Flag = V_Flag

In Filter, Filter where O_Flag =1

Answer / azhar

Simple use sql override query:

select top1 * from TABLENAME order by ID,DATE

Answer / deepak

SQ --> Sorter (sort on date desc) --> Aggregator (select no ports so it will always return last row) --> Target

Answer / 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.

Answer / kalyan

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

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

what transformations are used for Variable port?

2 Answers  

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

Whats the difference between $, $$, $$$

9 Answers  

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  

Enlist the tasks for which source qualifier transformation is used.

0 Answers  

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

what is mapping parameter?

2 Answers   Cap Gemini,

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,