Announcements
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
Thank you. I will review and make sure there aren't any blank references.
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 <> ''
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156