Hi,
I have facing data loading related issue at the time of data loading into oracle table, following errors has occurred for all tables of my oracle library this is “XYZ”.
1: ERROR:WRITE ACCESS TO MEMBER XYZ.TRANS_DIM.DATA IS DENIED.
2: ERROR: ORACLE EXECUTE ERROR: ORA-00942 TABLE OR VIEW DOES NOT EXIST.
This all happens In SAS Data Integration studio. while data loading into dimensions table.
my source table is sas table and target table is oracle table in between i have used SCD type 2 transformation for loading data that time this error has occurred. i have tried so many time but my issue not resolve please give me right direction.
I have work on same issue from last 6 days, For that i have applied different techniques to solve it
Like:
1> I have check all permission of DATABASE And Application level Permissions.
2> i have create new job using all the oracle table to data processing.
3> Restarting object spawner in unix.
4> To implement all possible properties in the scd type 2
but still this issue comes in.
Please help me to solve it.
