Non-Materialized View

[rheytens]

I have a Source endpoint that is an ORACLE database from which I am able to read ORACLE table data.  Is there a way to read data from an ORACLE non-materialized view?

[john_wang · Accepted solution]

Hello @rheytens ,

Yes the regular view can be used as Full Load ONLY task. please follow below steps:

1. Create a task with Oracle source Endpoint

2. Turn off the Apply Changes and Store Changes, keep Full Load enabled

3. In the table selection window, choose the VIEW, as below sample:

Hope this helps.

John.

[rheytens]

That works!  Thank you John.

[john_wang]

Perfect! thank you for your support @rheytens !