DSXchange

You really should bookmark and read Vincent's blogs.

There are two threads on this subject - here is the other. Has some of the background left out of this one.

And note that your version - 7.5.2 - is not the same as the 7.5x2 version that will run PX jobs on Windows.

No-one is suggesting you use it in a job. Open it via the Manager. Look at the code there. Run it by 'Test'ing it in the Manager.

I wouldn't worry about a 'scripted' approach right now. You can connect to an Oracle 9i instances via an OCI9 stage right now, yes? Since that's the case, all you need to do is continue to use the 9i client and simply point it to a 10g instance. Will work fine. In other words, you shouldn't have to ...

Don't use the ODBC stage unless that's how you plan on accessing Oracle in your jobs. You really should be using the 'Plug-In Metadata' option and specifying one of the OCI stages for this. Have you setup your DataStage server for Oracle? That means either having an Oracle client setup and configure...

Open/Close for a Parallel job. He meant the 'Before SQL' or 'After SQL' tab of an OCI stage in a Server job can be used to call a stored procedure as long as they don't return anything.

Otherwise, use the STP or Stored Procedure stage which you have in your version.

47shailesh wrote:Transformer_0: ORA-01858: a non-numeric character was found where a numeric was expected.

Tha'ts not an error I would expect to come from a problem with a DATE field. Dollars to doughnuts it's coming from a different field you are populating - one defined as a NUMBER of some precision.

Welcome. Pretty big work order on a first post - tune a job for you. And made more difficult because we don't know any specifics of your job design. How about this? Identify your bottleneck or bottlenecks. Attack them one by one. If you mentioned that 'extracting takes 6 hours' you think it could ta...

There's no attachment and no way to 'attach' anything anyhow. For a screenshot, you'd need to host it somewhere - and there are numerous free images hosting services - and then use Img or URL tags to link it into a post.

I read in this forum that what I need is possible in two different ways: - by using an Universe stage and performing the join in the transformer - by preloading the data retrived from the hashed file in a before-stage routine and by using a transform function in the transformer key expression (is i...

What happened when you ran Exact Match searches for DS.TOOLS and DS.CHECKER ? I got quite a number of hits which answered both questions.

Please give that a shot and then let us know if you have any specific questions on either subject.

Yep, as noted several ways. Simplest would be the Pivot stage unless you are working with a huge volume of data as it can be a little... slow.

But in another sense, the upgrade of the product from 7.1 to 7.5 will automatically convert / upgrade all of the jobs as well - but as noted won't change one stage to another. If you are upgrading from an older version that only had an OCI8 stage to a version that supports the OCI9 stage as well, th...