DSXchange

I just came across this error message in a standard transformer in DataStage Server. I'm curious as to what the first step should be... bumping up the row buffer size until you no longer get the error or just disable row buffering for the job. chaitanyavm: DataStage Administrator should show you wha...

chucksmith wrote:What is PSFT EPM?

PeopleSoft Enterprise Performance Management:

http://www.peoplesoft.com/corp/en/produ ... /index.jsp

Is it just me, or is AuditStage 7.0 and 7.01 filled with so many bugs that the product is basically unusable at this release level?

I have a sequencer that is aborting at the end of it when it calls a routine activity (actually the routines runs, then the sequencer aborts). What I have a sequencer stage that has a link from every job activity the sequencer calls. After all have completed it moves on to a nested condition that te...

You will develop your routine, and it will work. After 30 days from first use, it will stop working. At this point, you will need to pay money to license your ODBC driver. This is not money to Ascential; this is money to the driver vendor. If you're not prepared to go this route, don't even start d...

What about trying something like this: Write a DataStage BASIC routine to find all the jobs called from a particular sequencer, and then goes to the log of those jobs to get entries and puts them in separate sequential files or one file with the jobname as key. The sequencer can then call the routin...

not sure if this will work, but you might want to try it:

export the job. rename the current job name in Manager. import the job you just exported. try compiling again.


Also, can you tell us if this job has compiled before in the past or is this a new design that has never compiled before?

When I go to Director and view the status , it shows "Running". Ketfos Normally the above problem, when the job isn't actually running, is fixed in Directory by choosing Job...Clear Status File. However there may be more since another user is attached. Try Neena's kill -9 pid recommendati...

The decision to go with Ascential was a bit of a shock to many EPM customers as Informatica had been the ETL tool of choice for PeopleSoft through several releases. It took them about 5 months after the announcement to get documentation out on the setup of Ascential. That is why enterprises using P...

another agreeer here: stick with column generated; try to avoid fully generated; don't be afraid of using user-defined, but choose column generated over user defined when you have a choice.

Inprocess and interprocess row buffering can definitely improve performance, but they can also hurt performance. I don't like the idea of using the project wide setting, but analyze and test on a job by job basis for complex jobs and jobs that need performance improving. Also, don't forget to work w...

Yeah, the forum is great for some specific questions, but if you are not familiar with some of the DataStage entities then the best place to start is in class or reading the .pdf manuals. One thing to note about Adobe Acrobat Reader... if you download the free reader from adobe.com, there is an opti...

a little off topic here: Nivas, can you tell us what the DataStage job market is like in Boston? I was curious is they had more DS users there since Ascential US is based there or if there was more competition from Ascential consulting versus independent consulting.

I know the provied system @variables are read-only, but I was curious if there is any way to create your own @variables that will show up in the ... menu for system variable...

Thanks

Yes, Amos...you really need to let us curious minds know what technical/business requirement is driving your need to truncate a project! Let's see how creative we can be too. As far as this comment: I was thinking of a way to create a loop that goes over DS_JOBS and for each jobno delets the RT_LOGx...