DSXchange

Hi,
I have a job which reads data from a staging table (Odbc stage) & loads the data to target Teradata table (Teradata Multiload).

ODBC-(Source)-->Transformer-->Teradata Multiload(Target)

In target stage we have delete in before sql & update in after sql. These delete & update are on the same table on which we insert the data. The error which I am getting is as below


-----------------------------------------------------

Mload_STG_NAME,0: Failure during execution of operator logic. [api/operator_rep.C:331]

Mload_STG_NAME,0: Fatal Error: Fatal: Timeout reached before MultiLoad opened STG_NAME.TABLE_NAME ** Check MultiLoad report ** [dscapiop.C:1882]

Step execution finished with status = FAILED. [sc/sc_api.C:252]

----------------------------------------------------

More info on Multilaod stage
Tab name--Stage--> Advanced Execution mode - <default>
Combinabilty mode <Auto>
Tab name--Input-->General Checked (Overwrite existing script & Use named pipe box), data format is Fast Load

Tab name--Input-->Multiload/Tpump Load utility-Multiload,
Load type-Insert

Tab name--Input-->Limit Setting all set to default '0'


Tab name--Input-->Partitioning Auto

Tab name--Input--> Advanced Buffering mode--Default

Please help me to resolve this issue

Thanks ,