Initial Extract For Address Dimension Contains Duplicate Records (Doc ID 2161359.1)

Last updated on JULY 22, 2016

Applies to:

Oracle Utilities Mobile Workforce Management - Version 2.2.0 and later
Oracle Real-Time Scheduler - Version 2.2.0 and later
Oracle Utilities Analytics Base Platform - Version N/A and later
Information in this document applies to any platform.

Goal

On : OCI Cloud Ops

ACTUAL BEHAVIOR
---------------
The output of below query gives duplicates. For some address there are 22 duplicates in a single extract file.

select count(1),src_addr_id from stg_addr_ext group by src_addr_id having count(1) > 1 order by count(1) desc;
 

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