DSXchange

Not really. You have to ensure that the parent record (in the referenced table) is in place before writing any child record (in the referencing table).

The only exception is when you use the Slowly Changing Dimension stage (version 8.0 and later), which manages this for you.

Information Server Administrator console: Yes
WebSphere Application Server Administration console: Yes
DataStage Administrator client: No

You could pre-process the file to add terminators. In DataStage BASIC you would use ReadBlk to read one byte (record type) then ReadBlk to read the requisite number of bytes for the remainder of that data. Use WriteSeq to write the result with an automatically-added line terminator. You could so the...

ONE instance of a job can run with no invocation ID (that is, an invocation ID of ""). However, a second instance with the same invocation ID, whatever it is, will fail to start (job not in a runnable state: already running).

Moderator: please move to Server forum

Please be specific about what you are doing in the Aggregator stage, whether its input is sorted, and some idea of the data volume you are processing.

Don't push, especially on weekends.

Transformer stage functions use "To" (for example DecimalToString) and one-based numbering.

Modify stage functions use "_from_" (for example string_from_decimal) and zero-based numbering.

If there is a small, finite number of col1 (depth) values you could accumulate/reset in a Transformer stage variable for each. Output only the stage variable for the current value of depth. Perhaps use four outputs into a Funnel stage.

However this was one of a series of clearly server job questions, so presumably the interviewer was concentrating on server job knowledge.

Please confirm HOW you "tried that".

Welcome aboard.

Please verify your DataStage version number - there is no version 6.5 as far as I am aware.

Moderator: please move to Server forum

Magic idea: install DataStage on a supported operating system.

I would use the DIGITS Transform then concatenation.

Are the links still [Reject] links?

7.5x2 to 7.5 should be OK without tweaking anything.

7.5x2 to 7.1 may work, if you tolerate the errors during import (7.5 functionality that is not supported in 7.1), but there are no guarantees.

7.x to 6.x or earlier will not work.