Should CD_CREW Have Property SCD TYPE = 2 in MWM BI Data Mapping Guide?
(Doc ID 1603881.1)
Last updated on SEPTEMBER 14, 2021
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.4.0.0.0 and laterInformation in this document applies to any platform.
Goal
OUASA 2.4.0
Are there discrepencies in the Oracle Utilities Mobile Workforce Management Business Intelligence Data Mapping Guide and MWM mapping configured on OWB for CD_CREW?
Oracle Utilities Mobile Workforce Management Business Intelligence Data Mapping Guide - Dimension Extract Programs - Crew Dimension:
the Load Table Name is CD_CREW.
Oracle Utilities Mobile Workforce Management Business Intelligence Data Mapping Guide - Dimension Table Schema - Crew Dimension:
Property SCD Type = 2
On OWB, Dimension CD_CREW is not configured for SCD Type 2. It has Slowly Changing Dimension = Type 1: Do not keep history.
The loading type handled in the mapping also has insert and contradicts the SCD type2 concept.
Whenever ETL is performed on CREW Mapping, it is noticed that CD_CREW reloads the same data.
Clarification is needed on whether the above highlighted issues are documentation bugs or tool configuration slips.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |