DSXchange

sam334

rkashyap,
I actually first told our DBA to do a database maintenance. All the maintenance was done in regular basis. After changing the transaction count performance improved but though 1.30 hour for 10 million record would be too much.

Thanks.

sam334

Thanks Ray. Unfortunate we do not have performance analysis tool. I checked the logs and tested the job which was actually delayed. The transaction count and array was 50 and 50. I changed those to 2000 transaction count and 1000 array. I can see definitely performance is improved. So, changing the ...

sam334

Hi All, I am having one issue in sequencer job running. I searched the forum and there is a related topic but does not really make sense. Now, the sequencer was fine, running perfectly where we have two large loads and one process control update. I added one more job at end and after the migration i...

sam334

Hi All,
I followed the way of dumping the data in txt format and then load it. There were some issues regarding the suffix. It is clear now.

Thanks a lot everyone.

sam334

Yes Craig. I dumped the data in a sequential file in text format. Seems like there are some issues. Let me check. I will get back asap.

sam334

Thanks Ray and Andy.

sam334

Craig ,
I used, TRIM, SUBSTRING. Any other possible function can I use.

Thanks.

sam334

Craig,
No, I am not.

Code: Select all

USERID = "kashmirakumar.basu           "
FIRST_NM = "Kashmera                    "
LAST_NM = "Basukumara                    "

This is the sample of error.. there are spaces between the last quote and last word

Thanks.

sam334

Hi, I have an issue which is giving me a lot of trouble.So, seek your help. I have a server job which inserts and updates new records for the employees who are newly recruited and moved to different department. It looks like, FTP stage- Transformer- Transformer-ODBC. (Second transformer is reference...

DSXchange

Search found 144 matches

Sequence Job running very slow.

Truncate Issue