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 <> ''
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148