My Oracle Support Banner

Incorrect Alias Generated for an ODI 12c Mapping with SET Operator Connected to Deduplicator (Doc ID 2065972.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


When Oracle Data Integrator (ODI) mappings have a SET operator connected to a DEDUPLICATOR/DISTICT, the outer part of SQL SELECT has an alias name SET_xxx_1 but the inner SQL has an alias name SET_xxx.

For example:


To view full details, 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 a vibrant support community of peers and Oracle experts.