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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / ankit kansal

Answer Posted / ankit kansal

By Default informtica finds a group on the basis of your group by check boxes and returns you last row of each group when you don't specify any group by clause then it takes whole data set as a single group and returns you the last row of that whole group...

please make me correct if i am wrong..

http://deepinopensource.blogspot.in

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is incremental aggregation?

1011

Is stop and abort are same in informatica?

943

Can we create two repositories on same database instance in oracle?

1011

Explain what are the different types of transformation available in informatica.

1034

Whats there in global repository

1641

How to extract sap data using informatica?

981

Explain how many types of dimensions are available in informatica?

1004

What are the different transaction levels available in transaction control transformation?

1114

How to load the data from a flat file into the target where the source flat file name changes daily?

1003

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1573

How to update or delete the rows in a target, which do not have key fields?

1115

What is the way to execute pl/sql script using informatica mapping?

1503

Does an informatica transformation support only aggregate expressions?

963

What are the different components of powercenter?

986

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1627