DSXchange

How could you expect to get one-to-many if you remove duplicates on both input links to a Join? You could only ever get one-to-one. It is perfectly OK to have duplicates on the inputs to a Join - or only on one input, if that's your requirement. Try discarding the Remove Duplicates stage on the righ...

Do an Import Selected. All the components in the export file will be listed on the screen.

Depends where the "total size" figure is coming from. The physical size of the hashed file includes free space which, if the load parameters take their defaults, will be about 20% of the overall size. On this basis a 1200MB hashed file could fit its data into a 999MB cache, since 80% of 1200 is 900....

DataStage has particular issues because of its extensive use of shared memory, for example for locks and process control semaphores. It is really tough to fail-over things that are in memory. But it's certainly possible to re-start things on the fail-over machine, provided all the required Repositor...

Hi, Is there a possibility for a DataSet stage in Parallel jobs to take input directly from a Sequential file No. A File Set stage can be convinced to do this, but a Data Set stage no. Even if the sequential file were in correct binary format, you have no mechanism for creating a (binary) Data Set ...

y?

No and no.

No.

It is created attribute-centric or element-centric (or some mixture thereof).

Harrass whoever created the file.

Or (and maybe better) in Manager choose Import > Table Definitions > Orchestrate then choose the third of the three options offered, the one that allows you to use orchdbutil to import the table definition. This will open extra fields in which you can supply the connectivity and authentication infor...

s_porkalai wrote:Is there any way of using DSLinkInfo to capture the row count in After job routine

DSGetLinkInfo()

Functions within the Transformer stage are 1-based, whereas everywhere else are zero-based.
Therefore Field("09:59:51 03 JUN 1997", " ", 1, 3) would return "09:59:51 03 JUN"

Is your client machine running Windows XP sp2? If so, do you have the DataStage xpsp2 client patch?

Wasim was not using a hashed file, the only known mechanism for which the NOTFOUND link variable is reliable.

A hash file is just not the same (since it doesn't exist!)

Surely how DataStage parsed the XML file is how you should parse an attribute-centric XML file such as the one you have. If you really want a tree structure get "them" to create an element-centric XML file, or at the very least to supply a DTD.

What is returned through SystemReturnCode argument? This is the exit status of the UNIX command. Also, try leaving off the <1> from the output argument when logging the value; the command's first output character may have been a line feed. Instead of output<1> use just output in DSLogInfo() or Conve...