Initial Extract For Address Dimension Contains Duplicate Records
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.
On : OCI Cloud Ops
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;
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