I am attempting to both read and load to the same view of a table within a DataStage job, using Multiload and getting an error which DataStage gives as "APT_TeraSync: could not create operator sync table". When I read via a table and loaded via a view, this worked fine.
This seems like a Teradata issue (possibly with Multiload), rather than DataStage. I would appreciate input on this.
The user needs to have permissions to create terasync table on the database mentioned. The database could be default database mentioned in the Multiload Stage, or the database mentioned in APT_TERA_SYNC_DATABASE.