DSXchange

It is an SQL Server database. I spoke to our DBA about it and they suggested that the tables were not efficiently designed. The odd thing is that it was running fine, but recently performance has gone bad - the use of the server recently has increased 8-fold, this must have had a detrimental impact....

Thanks, that is a useful technique to bear in mind for future. In this case I do indeed have a seperate job to extract from the tables, so can eliminate the idea of 'back pressure'

Back to the drawing board, I need more coffee...

Cheers,
StuM

Hi again, I think I misunderstood your reply DSguru2B. Basically, I have a requirement that at any one time the table will hold the latest data for a number of rows. Each day when the suite is run, I am updating the table where the row exists, inserting new rows and leaving well alone rows which hav...

Thanks DSguru2B - I will replace the ODBC stage with a write to a DataSet and see how we go.

Cheers,
StuM

[edited to correct who it was addressed to!)

Thanks Ray, I will give that a go. Strangely enough, our retrieval from the tables is now displaying similar levels of poor performance.

Cheers,
Stu

Hi All, I am suffering performance issues with the EE ODBC stage that I hope you might be able to help me out with. I have had a search, but couldn't find the solution. Basically, we have several (Parallel) jobs that run sequentially, each of them loading up either sequential files or datasets to MS...

Now make sure you parse the last column correctly(since you know the length of the last-but one column) so that you get your output correct. :wink: Thanks, will do. Found the culprit - the file is a concatenation of multiple files, each with there own header. I (wrongly) thought that all of these h...

Hi Kris,

I made the changes that you suggested to the table definition and... it worked! Time to have another look at the data I guess!

TGI Friday

Thanks very much for your time.

Regards
Stu

Hi All, I am trying to read a fixed width file into a sequential file stage of a Parallel job. I set up the format as: Record Length=Fixed I have set up the column definitions with multiple fields, all character and of various lengths. I have double checked and the input file is the same length as t...

Brilliant! Thanks for your help Ashwin, I will modify it accordingly.

Kind regards
StuM

ashwin141 wrote:Are you trying to do this in PX or Server?

In PX...

Thanks
StuM

Try chaging the link type or check the reject option. Your problem is still not clear. Thanks. Basically the job functions are: * Read in a sequential file * Use a transform to split: 1. Header to another transform, which converts the format and writes out to a sequential file. 2. Data to a sequent...

Hi All, I have a relatively simple job and part of it is to take two sequential files and put through a funnel to combine them. They have different attributes on input, so I wanted to set the output columns to a single fixed width field (the same for both files) and then put through the funnel. Howe...

Great, thanks very much for your help.

Regards
StuM

Thanks again - use of %year_cutoffyy achieved the desired result.

Could anyone tell me how this works. I am using %2000yy. What theoretically will happen in 2100?

Thanks in advance.
StuM