My Oracle Support Banner

Database Views With Rank Operations Are Omitted on Data Lineage (Doc ID 2377490.1)

Last updated on MARCH 26, 2018

Applies to:

Oracle Enterprise Metadata Management - Version and later
Information in this document applies to any platform.


On Oracle Enterprise Metadata Management (OEMM), database views that use "rank" operations do not produces the proper lineage.

Below is an example for a view that uses rank operation:

create view v as 

case when t.n>t.m then 1 else 2 end as attr_case, 
rank() over(partition by n 
            order by m) as attr_rank 

from t

After harvested into OEMM, the "data lineage" is not produced for the view that contains a rank operation as demonstrated in the screen shot below:




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.