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

What is incremental aggregation and how it is done?

Answer Posted / ankit kansal

Incremental Aggregation ->

Incremental Aggregation is a technique to populate data on your aggregated tables or materialized view incrementally.

It takes new incoming data only based upon last updated column value or created_date time stamp column and thus uses its own cache created/updated earlier and updated the table as required.

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

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2142


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1061


update strategy transformation in informatica

1017


What do you mean by channel change?

966


Write the advantages of partitioning a session?

1209


Design a mapping to load the cumulative sum of salaries of employees into target table?

1424


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1223


How you know when to use a static cache and dynamic cache in lookup transformation?

1795


How to generate sequence numbers?

1031


How to call shell scripts from informatica?

938


hi real timers . iam waiting for ur reply regarding ETL TESTING

2209


What is rank transformation?

931


What could be the possible resons of locks by user?

1035


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1976


On which transformations you created partitions in your project?

1253