Hi
I am trying to build an interface which will move bulk data from an Oracle database Table (11G R2) into a TeraData database table using ODI 11.1.1.7? I selected the "LKM SQL TO TERADATA(TTU) as LKM and "IKM TeraData Control Append" as IKM.
When I execute the interface via ODI Studio in a WINDOWS 7 box, the interface execution does not get completed and it is stuck for hours in the step Load/pipe to staging area (Order :- 190) with out throwing out any error.
I have Tera Data Utilities installed in the same machine (Local Agent runs via ODI Studio). I observe the load scripts and data file being created in the temporary folder mentioned in the LKM properties. It also starts MLOAD utility (Can see it in Task Manager).
Can you please let me know any work around? Any help around this is most welcome.Also if there are any patches or bugs related to this. Not sure whether it has any issues with unload step in JYTHON script referred in the step Load/pipe to staging area (Order :- 190)
PS :- I tried to run through the script generated by LKM directly through MLOAD and it got loaded successfully.
Thanks