My Oracle Support Banner

Eliminate Duplicates Issue (Doc ID 2852159.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Stream Analytics - Version 19.1.0.0.6 and later
Information in this document applies to any platform.

Goal

Customer have identified a situation where Pattern called Eliminate Duplicates does not work as expected. The situation was detected when this pattern/stage is placed after a Left Outer Join stage where the passing event is enriched from a reference (stream or table) and this stage produces more events (based on number of records in the reference). It expected that even in the case when multiple events enters the stage at the very same time the Eliminate Duplicates pattern will forward only one of the events.

I do attache the minimal example exported from OSA. Please watch the last stage called Drop_dup_clients and look for attribute ClientSiebleId=24003804. This attribute is which used as Duplicate Criteria.
 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.