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

what is incremental aggregation ,with example?

Question Posted / sehaj

Answer Posted / sehaj

Incremental aggregation is nothing but a method of maintaing
new records in the target when we use an aggregator in our
mapping..
With incremental aggregation only those records which are
new in the source are processed in the mapping excluding
those which have been processed.
The data which was earlier present in the source n has been
processed is stored in the cache and the new records are
processed along with them.
For this we need to select the option INCREMENTAL
AGGREGATION from session properties.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What if the source is a flat-file?

1168

Can you generate sequence numbers without using the sequence generator transformation?

1162

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2290

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1212

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2414

Enlist the advantages of informatica.

1099

What is session task and command task?

1395

waht type of interface is used for testing the data in informatica

2298

COM components can be used in Informatica

2454

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1731

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1166

Explain the types of transformations?

1102

How can we update a record in the target table without using update strategy?

1203

What is the need of etl tools?

1181

What are the differences between oltp and olap?

1018