DSXchange

The audit table can also be useful in recovery after failure if you need to re-run the extractions. (Though, if you use a staging area, you won't need to go right back to original source.)

A job batch (created in Director) is a job sequence, though with far less control over what's happening. Take the trouble to learn the job sequence GUI; you won't regret it.

Type dsjob alone (no parameters) to get the top-level syntax.

Type dsjob -run (no further parameters) to get the syntax for running jobs.

Cross-reference what you learn here back to the manual.

Do you have a consistent naming convention for the input link to the target stage and for the output link from the source stage? And for the stages themselves? And for the intermediate active stage (which you will need for DSGetLinkInfo)? If not, some complexity will be introduced, and you may be be...

No kind of job can reset itself. It must be reset from a higher level. Perhaps you need to build a master job sequence.

You can also use External Source or External Target stages if the number of records is small, using the somewhat less efficient UVread and UVwrite executables. Note that these stages will need to be constrained to execute in a node pool all of whose nodes are on the same machine as the DataStage ser...

You must specify any field on which you want to perform any kind of operation (such as Trim() in your case). Therefore RCP is not going to help. Nor is a shared container unless metadata are identical. Investigate propagating derivation expression ("derivation substitution") within the Transformer s...

What - precisely - is coming from the mainframe? Are there any packed decimal fields? Do you have a COBOL FD? Did you import the table definition from that?

If the record delimiter really is 0x0A you can specify "UNIX newline" for this property. Or you can specify the three digit decimal code (010).

An import error occurs in an importing stage, not in a Transformer stage. It has no relationship, therefore, to the function you have described. Inspect the generated OSH, determine which stage generates an import operator. Add a rejects link to that stage, leading into a Peek stage so you can see w...

In a job control routine (or job sequence).

There is a command line interface for QualityStage (if that's all you want to do). There are three scripts (in the Scripts directory) for each deployed job; one suffix for each run mode. See page 8-8 of the QualityStage Designer User Guide for more information, If you are invoking QualityStage from ...

Can any one tell me how to craete a before job subroutine using basic functions for data cleansing. I need subroutine code for data cleansing. You create the routine as type "before/after subroutine" in the Routines branch, and refer to it in the job properties dialog in the before-job subroutine f...

Yes

Never make table name a parameter if you ever want usage analysis or lineage analysis or impact analysis to work properly.