Answer / jhilam roy

Sorry guys...correction...If you do not select any group by
port in an Aggregator transformation and also want the first
record of any input record set, then, simply use the FIRST
function with no group by ports selected. Because, if there
is no group by ports selected, by default, FIRST treats all
rows as one group, returning one value. However, make sure
that the first record is not NULL. If a value is NULL, FIRST
ignores the row.

Answer / jayesh

Dont use group by.By default it will give last row.To
override it,use FIRST function.

Answer / jhilam roy

Simple answer: NO, provided, only the Aggregator
transformation is used.
In an Aggregator transformation, if no port is selected as
Group By, then by default, the PowerCenter Sever returns the
very last row of the input record set, definitely not the
first one.
It scans sequentially starting from the first port of the
input set and continues till the last port is hit. If it
fails to find any port designated as Group By, the default
nature is to return the last record of the input record set
to the downstream transformation or target.

Any updation is appreciated.

Jhilam

Answer / naresh

I have column like col1,col2,col3 i am using first function
in col2 it work only that col2 i want first record means
col1,col2,col3 all first values How to get Please give me
solution.

Answer / janardhan

Hi Guys, I need sql query for the above functionality.
I mean sql query to get last record from 10 records same like aggregator transformation in informatica which gives last record if we don't give any group by.

Answer / bala

@abhinav...
How can you sort records by using rownum...its not possible

Answer / venkat

Yes, we can get first record using aggregator below are the
steps:
First need to sort all the records by desc and connect to
aggregator transformation than connect to target without
using gropby port than you will get first record.

Ask me any questions to <ittoolboxdwh@gmail.com> this is my
mailid.

Cheers
Venkat.

Answer / abhinav

hey I am having one answer regarding the same.may be it
will work.

SQ (sql override)(select * from emp1 order by rownum desc)--
>aggregator-->target

thanks
Abhinav

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  

What is souce qualifier transformation it is active or passive

2 Answers   HCL,

What are the types of error logs available in Informatica?

1 Answers  

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

how can we run workflow with pmcmd?

3 Answers   Wipro,

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

0 Answers  

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

What are the basic needs to join two sources in a source qualifier?

3 Answers  

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

What are the differences between a connected lookup and unconnected lookup?

0 Answers