DSXchange

Anything you like

AuditStage - formerly known as Quality Manager - is typically used as an independent analysis tool, rather than being used in a DataStage stream.

(1) Yes
(2) The server Transformer stage is not compiled with a C++ compiler.

Can you find any example where the input column is decimal[15,0] and the output is int32? It's just a warning that some decimal[15,0] numbers won't fit into an int32; you could demote it using a message handler.

The Aggregator stage can do mean and count missing values (from which you can calculate % missing values).

No matter which tool you use you need to take two passes through the data to calculate median.

Is your client running on Windows XP sp2 ? I have seen this on a couple of sites; the version is always 7.5.x. I do not know the cause.

Recursion is multiple runs anyway. Why not keep it simple? Use StartLoop and EndLoop activities in a job sequence, toggle the file names as advised in the other post, and provide an appropriate exit condition.

Only the vendor can supply a valid licence file. Contact your support provider. It may be possible, if you have two systems, to move the licence file from the other system, but nothing is guaranteed.

The only legal fix is to purchase a licence for the ODBC driver from Data Direct. See this post for example. Chances are that the company where the "fix" was applied already had an enterprise-wide licence from Data Direct.

You probably need a Routine to test whether an email address is valid or not. The same routine could return the valid or invalid address via system variables such as @USER0 through @USER4. It will help if you can exactly specify your requirements; in particular exactly which characters are legal (fo...

Check with your Oracle DBA that your job is not competing with itself for a lock on the table. Check with your DS Administrator that the job really is running (a status of "running" does not necessarily mean that the job is running - it can also mean that the job aborted without getting the chance t...

You need some kind of persistent "memory" of the file most recently processed. Because the file names will be parameters you can get this from the most recent "job started" log entry (in a Routine activity). Or you can design to store it in a third file somewhere. Pick up the name in a Routine or Ex...

Use Int() function to get the largest integer less than or equal to a particular number.

Depends what version. Early versions of the ORABULK stage were written as active, so that it could support an after-stage subroutine via which you could invoke sqlldr.

As you've described the algorithm the output file must end up exactly the same as the input file. Can you clarify the algorithm to show how it might be different?