MR datamart - initial integration - restarted

(0) Share

Report

Posted on by LsmithWipfli

136

If an initial integration process is "disabled then enabled again, would there be duplicate records in the datamart?

I was in the process of rebuilding the datamart and accidentally closed the Console. When I opened it back up, it looked the Initial integration had stopped. I disabled it then started the Enable again. It looks like it started over but now I wonder if there will be duplicate records from the initial start of the integration. Please let me know if I need to completely rebuild the datamart again.

Thank you, Linda Smith

All responses (2)

Answers (0)

LsmithWipfli 136 on at

Like (0)

Report

RE: MR datamart - initial integration - restarted

Thank you. I will review and make sure there aren't any blank references.
Brian_IL 705 on at

Like (0)

Report

RE: MR datamart - initial integration - restarted

I haven't seen a discussion how the integration process handles existing records in the Datamart, but the following info may help.

Records in the Fact and DimensionValue tables in the Datamart may have the versionend field marked, showing the earlier version of a record has been replaced by an updated version. This issue was discussed in an old SL2015 bug report related to MR duplicating records and causing the Datamart to grow. The report explained how to identify and clean up those records that would not be referenced by the MR reports.

If you query the Datamart and find unreferenced records, a rebuild would be the easiest method be sure the Datamart is cleaned up.

select count(*) from datamart.fact

select count(*) from datamart.fact where versionend <> ''

select count(*) from datamart.DimensionValue

select count(*) from datamart.DimensionValue where versionend <> ''