It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×4,712
×481
×64

question asked: Nov 15 '17, 10:17 a.m.
question was seen: 1,090 times
last updated: Nov 15 '17, 9:15 p.m.

Related questions

Is it possible to scrub Data-Mart data from the DCC database?

0
Georg Kellner (840●4●81●109) | asked Nov 15 '17, 10:17 a.m.

We've made a mistake in configuring the DCC collection jobs, so the data-mart data collection ran every our, which obviously results in a slightly big database.
(DB size ~300 GB, RICALM and RIDW ~180 GB)

Is it possible to delete unneeded data-mart data from the database or to reindex this kind of data to stop the daba growing fast?

I've rescheduled the jobs to run only once a day.

Greetings Georg.

Accepted answer

0
permanent link
Kenji Sarai (960●3●9) | answered Nov 15 '17, 9:15 p.m.

Hi Georg,

Yes, it is definitely not a good idea to run data-mart data collection every hour. Perhaps they will not finish and these jobs get jammed.

However, it should not affect the database size, as data in data-mart is cleared every time before new data-mart jobs run. Data-mart data is not an incremental, but re-calculated every time it runs.

Make sure to run the "Data Cleanup" and "Delete Fact table Data" job in data-mart. So the old data should be clean up and reduce the size of database. It could be that the increase in database size is caused by increase in archive log files in database. Check with your DBA.

Georg Kellner selected this answer as the correct answer

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.