Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / naresh_infa96

If you're using Aggregator Trasnformation without using group by on any port then the aggreagtor TXNs consider whole table as one group and gives the last row as output.

Why last row as Output : by default aggregator uses MAX() function

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to configure mapping in informatica?

1174


tell me about your project functionality

2347


What is the procedure for creating independent data marts from informatica 7.1?

1067


How to use procedural logic inside infromatica?

1247


What is difference between a gateway node and worker node?

1143


How can informatica be used for an organization?

1220


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1173


In how many ways we can create ports?

1123


Why sorter is an active transformation?

1198


What is exclusive and normal mode for repository services?

1146


How can we use mapping variables in informatica?

1064


how to create user defined function (udf) in informatica

1313


What is incremental aggregation?

1091


Explain the tuning lookup transformation - informatica

996


What is the meaning of decode in informatica?

1122