TDMload stage error:Bad keyword in the IMPORT command

[Lavanya B]

Hi,
I have parallel job where data is coming from DRS stage(67 rows), then lookup is performed with ODBC stage(reference data, 1.5 million rows) which is then loaded into tdmload stage.

The job aborts with the error:Fatal Error: Fatal: MultiLoad returned: 8 ** Please refer to statements in /data/projects/vsd_dwhouse/data/VSD_PROD_MKTG/Logs/RETURN_ARS_RPT2 to resolve the issue **

In the mload generated file, the error obaserved is Bad keyword in the IMPORT command at position 110: Expected "LAYOUT" but found "AXSMOD".

Please help us in resolving this issue

Thanks

[/img][/list]

[ray.wurlod]

Welcome aboard.

The error has come from the Teradata MLoad stage, in particular from the script that it has generated. Please verify that all settings in this stage are correct.

[keshav0307]

remove the line , where written like :

/*NT*/ \\.\pipe\tdmpipe_DSLink71. AXSMOD np_AXSMOD.dll