DSXchange

The Pivot stage has its own manual (Pivot.pdf). Read that first, it contains good descriptions and examples.

Hi, I am facing similar problem. When i try to import a dsx file to another project, i get a similar error and. Could someone let me know how to grant access to the project directory ? Many Thanks, Sidhartha First you need to grant yourself access that allows you to grant access. (Before we can def...

ray.wurlod wrote:I believe there's an inbuilt rule to convert to scientific notation when there are four or more zeroes immediately following the decimal place.

What part of that was unclear?

QualityStage plug-in comes with QualityStage, and must be separately installed. It does not require RTI components, instead it uses its own, similar mechanism that runs as qsrtmngr (which also needs to be installed).

My question about -ipe.env was not what it does, but why you have two.

Ramifications are primarily the danger that the job will abort if the data are not sorted. APT_NO_SORT_INSERTION prevents tsort operators being inserted into the design when the score is composed. No-one thought to ask in what mode the Funnel stage was set to operate. Continuous funnel is like round...

It is an absolute rule that a job parameter's value can not be changed once the job is running.
Can you use three parameters, one for each stage? If not, consider a modular design that involves three separate jobs.

Enrol on the Server to Parallel Transition Lab offered by DCS Strategies (the company that funds this site).

Entries beginning ##E are errors, ##W are warnings and ##I are informational messages.

It's a free country - you can expect whatever you like.

But you won't get any alternatives from here, at least not from the experienced developers.

Those performance statistics you get in Designer are meaningless anyway. Don't mourn their loss.

There should be no problem generating the Max(upd_dt_time) from a parallel job. You can, indeed, still do this in a server job, and load the result into a hashed file, or the job's user status area. The job sequence can then read it from the hashed file or user status area and supply the value to th...

It doesn't have to be a database - you can do the same thing with a text file. But, as you noted, you have to be careful with the order of operations - that you do not delete the file before reading the needed contents from it.

Maybe someone has created a File Set or a Lookup File Set but incorrectly specified a control file name with a ".ds" suffix.

That is not the case.

In the 7.1 job the stage is version 1.1.
In the 7.5 job the stage is still version 1.1.

No conversion or transformation happens. The "plug in" architecture of DataStage is what allows this to work.

Etiquette Note We don't do urgent here. If you want urgent answers, sign up with your support provider for premium service, and learn the true cost of urgent. Reconsider your requirement. Is calling a Stored Procedure for every row processed so necessary? It will be very slow. Can you not replicate...