How to Merge Cuts of Interval Data in Meter Data Applications - Not Using INTDJOIN (Doc ID 1271117.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Utilities Meter Data Management - Version: 1.6.1 and later   [Release: 1.6 and later ]
LODESTAR EIP - Version: 1.6.1 and later    [Release: 1.6 and later]
Oracle Utilities Billing Component - Version: 1.6.1 and later    [Release: 1.6 and later]
Oracle Utilities Load Profiling and Settlement - Version: 1.6.1 and later    [Release: 1.6 and later]
Oracle Utilities Portfolio Management - Version: 1.6.1 and later    [Release: 1.6 and later]
Information in this document applies to any platform.

Goal

Is there an easy way, other than using INTDJOIN, to merge two cuts of data that have the same METER_ID;CHANNEL and START/STOP READTIME?


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