DSXchange

The UtilityRunJob in the Transformer is given as the following. UtilityRunJob('SubMasterLoadBWFiles','MeridiumApplicationServer=' : ToSubMasterLoadBWFiles.Meridium_Application_Server : '|MeridiumDatasource=' : ToSubMasterLoadBWFiles.Meridium_Datasource : '|MeridiumUserId=' : ToSubMasterLoadBWFiles....

Hi, My jobs got aborted with the below log. These jobs were working fine till yesterday. No changes were made then after and when i executed today it got aborted with the specified warning messages. "Stage Lkp_NMBD_AUTO. with .TrnLkp_TADDRESS_JP after the occurring of ABORT cleanup in the midst...

I am comparing seq file data with table data. 3 keys combination is used as primary key. But some of my record's key column values are null. Pls suggest me, how to compare null values? Hi, You can preprocess it using NVL functions which will replace null with the prescribed text. regards Murugan

Hi, I am creating a hash file with 3 million records and its following error: "HASH_DW_GRID..HASH_DW_GRID_APIGG.loDW_GRID: DSD.UVOpen mkdbfile: cannot create file /vol02/home/dsadm/hash/DW_GRID_APIGG" This hash file job was running successfully till yesterday and no changes has been made ...

Hi , I would like to know whether there is any specific UNIX sort command which will sort huge files.say for ex : 2GB or more size of file. Each record in file is 16747 in length. We have tried with UNIX command sort -S , but it is failing for huge data files. I saw in UNIX man , there is large file...

This is a message after the reset: From previous run DataStage Job 98 Phantom 5020 Program "JOB.1427108223.DT.1437338697.TRANS1": Line 43, Exception raised in GCI subroutine: Access violation. Attempting to Cleanup after ABORT raised in stage my_unload_to_seqOCI..Transformer_7 Program &qu...

So do you always write only one record to the output file? Or do you process all of the incoming data, write some/all to the output and then always append one more record to the file? More of a curiosity than anything. I'd suggest you write an 'after job' routine. Pass it in the Stage Name of the T...

You're right, an empty source file will process zero records in the job and then nothing will be written to the target file. What is special about this 'one record' that needs to be written when you have no input? Describe it, please. Hi, Thank you for your reply, The output file provides informati...

Hi , I wanna know, how is it able to write one record to output file, if the input file is a zero byte file, means there is no data in input file. I need one record to be written to output file. Both are sequential flat files. Please assist me in this regard Thank you in advance regards Murugan

I would like to know the different ways which are generally used for performance tuning of Server jobs. Kindly reply me in this regard.