DSXchange

You may need to register the Oracle plug-in.

Welcome aboard. Are you running on an approved version/variant of Red Hat Linux? You probably need to take this one up with your official support provider if it's occurring reliably.

You are seeking to have your cake and eat it too. You can have one or the other, but not both. Invoking the Exception Handler causes the sequence to finish successfully, which clears all checkpoints. Use explicit failure triggers instead.

There isn't one unless each string field is quoted. You can read the entire line as a single string and parse it according to your own rules, for example in a Transfomer stage. This will actually give improved performance for large volumes because your parsing is being performed in parallel rather t...

What are you seeing in the Node Agent log?

Your data have violated referential integrity.

DataStage wrote:The insert or update value of the FOREIGN KEY "DOC_DW.SCARS_MARKS_TATTOOS.SCARS_MARKS_TATTOOS_MASTER_FK" is not equal to any value of the parent key of the parent table.

Don't do so. Check during ETL that you aren't.

It's OK provided that you guarantee - totally - that the data you are loading will not violate any constraints (typically uniqueness constraints in the case of PK index). You may also want to re-calculate table statistics after performing all these tasks.

It is working as expected.

Good.

Welcome aboard.

The short answer is to do something in the job that will cause the job to fail, such as directing the row to a link that has a one row limit or by engineering a deliberately impossible lookup with the Lookup Failed rule set to Fail.

If they're not correct orchadmin will throw an error message to that effect.

Just curious (and unable to check at the moment) - can you include the literal T in the format string? That would yield a simpler and self-documented solution.

Beta program is finished. The 8.5 version became generally available (for purchase) two weeks or so ago.

In particular look for the environment variable that controls maximum block size in a Data Set.

Or just different colored electrons along the wire?

The CDC stage is particularly for working with data captured from transaction logs by IBM's Change Data Capture product (formerly Data Mirror). Is this the purpose to which you are putting the stage? If not, investigate the Change Capture, Difference or Compare stages.