Should CD_CREW Have Property SCD TYPE = 2 in MWM BI Data Mapping Guide? (Doc ID 1603881.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.4.0.0.0 and later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms