DSXchange

Hi All, We have some 3 hash building jobs which usually load around 31564649 records in the hash. Daily i could see some 30000 to 50000 records increasing in the hash files.We use static hash file and use the option delete and create a new file regularly.Normally this job runs around 2hr 30 minutes....

Hi All, I have the following files in the directory inbox/sat ras.sat.trn. 20090103 .001902.00004358 ras.sat.trn. 20090612 .001903.00005339 ras.sat.trn. 20090723 .001902.00004358 The above file contains the date of the file creation in the filename. We just need to write a ksh shell script to check ...

Hi Ray,

Thanks for your inputs. No increase in data volumes. We just rolled back to oracle 9.0.0 and now it is running as expected. We have opened a Case Ticket for Oracle 9.2.0.8 patch issue.


Thanks,
Satheesh

Hi All, We have a Batch Job for POS file processing.Main issue is that POS file processing takes 80 seconds per file to complete. It usually takes 20-30 seconds per file.The Batch process usually takes 3 hour to process and now it took 4.5 hours, so we are missing our SLA. The performance de-gradati...

Thanks Ray

Hi All, I have a master sequence(Multiple instance job) and enable Add checkpoints and automatically handle activities that fail and the job contains exception_handler as well. Yesterday one of the instance jobsequence got aboeted with aborted/restartable and the main job_control batch got aborted.w...

Hi All, I have an oracle source stage and had a lookup with the hashed file. Oracle Data: A B C 11 11 -1 12 12 -1 Hashed File A B C 11 11 100 12 12 200 All the above three columns are key columns.All i need to do is get the C value from the hash file(100,200) and update it into the DB table. Please ...

Hi Ray,

I suspect there would be the space issue.I just checked my /Dstage mount point it is 85 % occupied. I am not sure what needs to be cleared on that.Engaged the infrastructure team on this issue.


Thanks,
Satheesh

Hi Ray,

Yesterday the same job runs within 3 hours time..but today it still running more than 7 hours..Still unknown about the issue.


Thanks,
Satheesh

Hi All, We have three hash building jobs in our project which is running longer than normal..some day it will run 3 hours and some days it will run 8 hours. 1.PatternHash-(No.of Rec:18330189) 2.Slinhash-(No.of Rec:18300807) 3.UpcHash-(No.of Rec:6631328) All the above jobs are creating new hash file ...

Hi All,

Is there any way to get the log of the corresponding routine after the successfull/abort completion.






Thanks,
Satheesh

Hi All, I have the below requirement, please let me know your thoughts on this. I have a table which contains the values for the pattern: Store_id, Pattern, Flg, Start_Date, End_Date 123, 801, N, 20081101, 20081110 123, 802, N , 20081111, 20081125 123, 803, Y , 20081126, 99991231 One more store tabl...

Hi chulett,

We have the max year as 9999.


Thanks,
Satheesh

Hi All, How to validate the Year portion only in the date. For eg: i have the below values from my source columns 2005 2006 2007 2008 999999 888888 I have to validate the above values to find out the valid year(2005,2006,2007,2008) otherwise it would reject the records..can you please give me your t...

Hi, Sorry, i missed to mentioned about the routine functionality. The routine(HashTableLookup) would return the value when it found in the particular hashed file. Otherwise it would return **RECORD NOT FOUND**. If no record found, return value is: "**RECORD NOT FOUND**". Please suggest me ...