DSXchange

1. Not automatic. But somewhere along that reject link - which is just another data stream in the job - you could lookup the sqlcode value. 2. No. Unlike server jobs, the database stage and the Transformer stage are separate in parallel jobs. Thus the Transformer stage does not have any access to da...

What are the permissions on dsstpora.so ? Are all the Oracle environment variables correctly set for the user ID under which jobs run ?

If the sort key is indexed with a B-tree index the sort is already done.

Look in the job log in the ANALYZERPROJECT project. It seems that the profiling did not complete successfully. Look for any warnings or errors in the log.

True but, in this case, you need to code for negative offsets in order for the date to be adjusted appropriately.

Hmm. Most of these inferred characteristics are taken from the frequency distributions, which would have to be done anyway, so I don't think you'd save much processing time. You can, of course, ignore those tabs on the Column Analysis details screen. Or cheat, with "Mark All Reviewed"!

How about floor?

It's complaining that one or more of your WVARCHAR columns is too wide - can you eliminate this column from the analysis?

Welcome aboard, Mike.

I'm not comfortable with "DSXI" as a term. Can you please be more specific? IBM's platform offering is called Information Server. Within that (on that platform) the principal cleansing component is called QualityStage.

Try modifying the metadata so that there is no space in the field name.

Only the ODBC stages (and the Dynamic RDBMS stage when database type is set to ODBC) use ODBC DSNs.

Don't know about magic, but Data Set and File Set segment files do have a very idiosyncratic naming convention that you might be able to leverage. There are probably some identifying bytes farther into the header than the first few bytes, but I haven't looked in there in some time.

Review the rtype argument for decimal conversion functions.

See if a server Sequential File stage - either in a server job or in a server shared container - can read this file properly. You can use a server shared container in a parallel job.

I think that's an internal one, vaguely seeing it back in about version 3.6. Get in touch with your official support provider.