Hi,
I have simple mapping in which I have source file as source and Teradata table as target. I am using ODI built-in "LKM File to Teradata (TTU)" KM.
My issue is that when I run the mapping. it always stuck at step "Load to staging area". It neither failing nor going in waiting state rather it keeps on running without any functionality performed. The code for this step is:
import os
logname = r"C:\SRC_FILES_DEV/C_0EMP.log"
scriptname = r"C:\SRC_FILES_DEV/C_0EMP.script"
options = r""
utility = r"""fastload %s < "%s" > "%s" """
loadcmd = utility % (options, scriptname, logname)
if os.system(loadcmd) <> 0 :
raise OdiKMException("ODIKM-STDKM-10011", "ODIKM-STDKM-10011: Load Error. See {0} for details",[logname])
Any help would be great.