DSXchange

In parallel jobs you don't do lookups with Transformer stage; there is an explicit Lookup stage. It supports an reject link down which input rows can be sent if the lookup fails. Alternately you can have all rows sent to the output of the Lookup stage; for those for which the lookup failed all field...

WHERE inside DataStage? Usually the method for a job is to set up a job parameter that references the environment variable; you can make reference to that job parameter wherever it is appropriate to do so within the job. Or in a job sequence you can do the same, or you can load the value into a user...

If your lookup fails and the Lookup Failed rule is Continue then every column from the reference input is set to NULL. You are not permitted to send NULL into an output field that it not nullable. Therefore, failure. Inspect the output fields' extended properties. Do you have Default property define...

Try putting the time component onto the timestamp. Oconv(Iconv(InLink.data_date, "DMDY"), "D-YMD[4,2,2]") : " 00:00:00" At least one of your input dates is wrong, because it's generating "-08-00" from the expression. You would do well to validate data_da...

Welcome aboard. There is no way to get a list of the jobs used in a job sequence until after the job sequence has been run, because the execution logic of the job sequence may cause some job activities to be skipped. If you need a list of the jobs in a job sequence (whether or not they will be execu...

That's weird. UniVerse error code 30001 decodes as "delete attempt on read-only file". I'm not aware that Version Control generates error codes of its own in this range. Are you 100% certain it occurred while selecting? Check your permissions in the Version project, perhaps.

Because you've cleared it, you have lost the capacity to debug it. If there was a core dump, you may be able to send that to your support provider to be analyzed.

DataStage is the better tool for this task which, again, is not really a profiling task. Profiling is "discovering what's really out there". Two file comparisons don't really come into it until you're profiling for foreign key candidates. In DataStage bring the two sources together in a Transformer ...

That's not really a profiling task, so I don't believe you're using the right tool choosing AuditStage. QualityStage is a tool that can perform probablilistic matching; I believe that would be the right tool for this circumstance. You could also use DataStage, but you'd also need to come up with you...

DEFFUN Test(Arg1,Arg2) CALLING "DSU.Test"

All user-defined server routines are cataloged with a "DSU." prefix.

Define "performance" in an ETL context. Then maybe we can help you.

Hint: rows/sec is an almost completely meaningless metric.

Create a job parameter using the Add Environment Variable... command button. Set the default value of the job parameter to the special token $PROJDEF to have it pick up the value from the project's default if no replacement value is given. Use a reference to the job parameter anywhere you need it in...

Define "performance" in an ETL context.

The ORDER BY clause is possibly helped by an index. B-tree indexes are already stored in sorted order.

DataStage has no such help.

There's no error in any of that.

Error messages begin with ##E.

Why do you want to look at Templates? They are stored on the client machine in a folder called Templates. For example if your DataStage client is installed in the default location, then Templates should be at the following pathname. C:\Program Files\Ascential\DataStage\Templates Categories you may h...