GeekInterview.com
Series: Subject:
Question: 28 of 392

Incremental Aggregator Transformation

If incremental aggregation option is checked in session properties will the new cache is created during every run?
Asked by: gpadmanaban | Member Since Jan-2011 | Asked on: Jan 8th, 2011

View all questions by gpadmanaban

Showing Answers 1 - 1 of 1 Answers
Thara Shri

Answered On : Feb 9th, 2012

Incremental aggregation creates a cache memory in the first run, in each successive runs, the cache is updated with new records( apart from the old records). Same cache but updated records. So you have to increase the size of the Data cache to accomodate the new set of files. (As when ever an incremental aggregtor function runs, the integration service creates a backup of the cache files each time you run the session).

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.