Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OCI Data Integration - Filter using row_number() over in Data Flow

edited Dec 13, 2022 4:17AM in Data Integration 2 comments

I'm hoping this is something obvious that I'm overlooking. What I'm trying to achieve is filtering a data source (ADW table) by partition and only keeping the top row for each one.

So far I have added the data source, created a filter and used the analytic function "row_number() over(..." with a filter condition of that = 1. However this throws an error when running stating "ORA-30483: window functions are not allowed here".

This is easily achieved using a cte query in sql, but I'm struggling to get it working the same way in OCI Data Integration.

Is anyone able to point me in the right direction?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!