DSXchange

Hi

There are no work tables or log tables or error tables before running the job. THe multiload also released on target table. Basically I am dropping all support tables and target table.I am recreating the target table before running the job.

thanks
Nivas

Hi Develop a job control and in that we can get the link info using DSGetLinkInfo routine. If the in and out row count is not equal we can abort the job. Using the constraints putting a condition for the date val also we can trap the invalid data into a error file. There are many ways. Generally the...

Hi The following is the error message from .rpt file created by MulitLoad Utility. ------------------------------------------------------------------------------------- 0001 .logtable ua_edw_devl.CKP_CLAIM_FS_PX1; 0002 .logon kansas/svundi,; **** 10:10:27 UTY8400 Default character set: ASCII **** 10...

HI Could you provide some more details. How do we find out the rsources which are not released. How do we release them manually. thanks Nivas Hi, At first glance it seems like a resource that was not properly released/closed due to the first run's crash. you'll manually need to release it or cleanup...

Hi I am developing a job wich move data from Oracle to Teradata. I am using Oraoci plugin for pulling data and Multiload Plugin for loading data to Teradata.The job uses outputlink name as pipe. Due to some reasons the job aborted first time . After fixing the problem I am running the job. THis time...

Hi I am trying to use Multiload Plugin in Parallel mode. The job is fine in sequential mode. But when I set the mode of execution in parallel mode the job is aborting. I have 4 four nodes. THe job is aborting . IN the .rpt file the error message I am getting is CKP tble already exists and returing e...

Hi The job is pulling data from Oracle using Oraoci Plugin and loading into Teradata using Multiload plugin. The job sometimes only runs successful. While the job fails in the table_name.rpt file sometimes it is writting upto before multiload acquisition stage and sometimes it is not writting any th...

HI Inside the OracleENterprise plugin for the columns type decimal I am getting the following error.Job is successful. Could any body please help me in this. Oracle_Enterprise_61: When checking operator: When binding output interface field "BIRTHWEIGHT" to field "BIRTHWEIGHT": Im...

HI I am trying to load data through TeradataMultiload Plugin. Inside the job I am calling Server side routine which get the max id from the column. I am incrementing the Id value in the Datastage job. I am getting the following error. trn,0: dspipe_wait(15030): Writer(11871) process has terminated. ...

Hi

I was able to call Server Job Routines in Parallel Extender in SMP.
Now I would like to call Server Job Routines in Parallel Extender in MPP.
Any suggestions are most welcome.

thanks
Nivas

Hi I am trying to merge two table using Merge stage on one column. In the properties Tab I provided value for KeyProperty=ACC_NBR and Sort order is default. I am getting the following error But when I tried by putting FileSet Stage after Merge Stage the error has gone. Could any body help me please ...

Hi

Can anybody explain the following warning.
Failed to connect to JobMonApp on port 13401
thanks
Nivas

Hi

I am trying to use Teradata Enterprise Stage. I am getting the following error
main_program: Fatal Error: APT_TeraSync: could not create operator sync table.
Could any body explain this Please.
thanks
Nivas

Hi Tony

Thanks for your immediate reply. I was just moved from St Louis to Boston.

thanks
Nivas

Hi

For deleting hash file entirely how do we do that. Please advice

thanks
Nivas