We are doing a data dump from table to table. There no transformation involved.
The Dataflow includes only below objects
1. Source Table
2. Query Transform
3. Target Table
Since, it is a direct a dump, insert query is pushed to database.
We are getting below error when the insert query is pushed to database.
We are able to insert data into target table, When I avoided push down to database.
Not sure, if this is a Oracle Schema access issue (or) BODS issue.
Could you please help us in fixing this issue.
Appreciate your Help...