DSXchange

Hi,

am getting the error in the sequential stage...as below...

SRC_SEQ,0: Delimiter for field "ASSET" not found; input: {0d}, at offset: 41
.
.
SRC_SEQ,0: Import complete. 1 records imported successfully, 1 rejected.

TIA
SAM

Hi,

I have a sequential file having footer record differrent format.
in sequential stage getting warning on the last record.
any workaround instead of multiple record type handling trick.

TIA
SAM

Ray,

Adding environment variable works both from administrator as well as designer. but as far as assigning default value, we can only assign in administrator. In designer it only prompt for parameter name & prompt.

thanks all, DRS works perfectly fine

Hi ErichG,

can u share with us, how much time it is taking to load 20mio records into oracle from seq file & what tuning u have done to optimize the performance

TIA
SAM

Hi ErichG,

can u share with us, how much time it is taking to load 20mio records into oracle from seq file & what tuning u have done to optimize the performance

TIA
SAM

Below is the config file ======================================= main_program: APT configuration file: /baselwb/dsadmhome/Ascential/DataStage/Configurations/HYDRA.apt { node "node1" { fastname "sgwbba05" pools "" resource disk "/baselwb/hydra1/Datasets" {pools...

I have tried to change the the PX configuration file from 2 nodes to 3 nodes, am getting the following error, pls advise,TIA XFM_Rec_Count: Failed to load the library "V0S117_LOADCLSCMDimStagingRecon_XFM_Rec_Count.o". Either the directory containing the library file is not on the library s...

After looking at the process id using cleanup resources. and after killing the pid using kill -9 <pid>, it does not work, it still says job is being accessed by another user. Once in issue the command "list_readu | grep RU | grep -v :" the process is still there

One of the most wanted option is to provide "dsjob -unlock jobname" kind of option. ofcourse with some restriction that only owner or dsadm or root can unlock the job.

thanks
SAM

Thanks, so CRC32 will return checksum value on record level...and based on that I need to decide, if the record needs to be inserted, deleted, modified...if you have implemented...example please, thanks

TIA
SAM

Thanks, I have a seq. file with record lenth of 800KB & it is having around 12m records. I want to load this file parallely. Currently i am doing a split on unix and loading the files in parallely. is there a better way using PX to load the file in parallel without doing split on unix.

TIA
SAM

Thanks Roy,
But if experienced folks like you can share some standards that will be great, we are still using 7.1r2, have not upgraded to 7.5.

TIA
SAM

DSXChange is Simply Great!!

Hi,
Do we have DSEE Standard docs on the forum and PX Best Practices,

TIA
SAM