Multiload reading and loading via view

Analytics

Multiload reading and loading via view

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.
1 REPLY

Re: Multiload reading and loading via view

Hi,

Hope this not too late.

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.