DSXchange

If the join key is indexed in Oracle it is likely that the join will be resolved in the indexes. Get Oracle to EXPLAIN its plan for resolving the join. This is likely to be far more efficient than anything you can accomplish in DataStage, and will involve less network traffic because you only send t...

Here is the approach I would use to achieve the requested result. Set up two stage variables in the Transformer stage, called svList (which becomes the output column containing the comma delimited list) and svPrevID. svList initialised to "" svPrevID initialised to -90909090 svList If InLi...

You have choices. You can run it from a CMD shell, you can right click and add execution options.

Add a reject link to the Sequential File stage itself, to capture any rows that do not match the defined metadata.

For example, are there any empty lines in the file?

The strings captured onto the reject link (which can be written to another file as a single VarChar) will help you to diagnose.

No, that's not right. Use -force as an option for the setup command (or the install command, depending which platform you're on).

Quite possibly, translation engines are getting better. But it would not be DataStage/QualityStage doing the work, which was the gist of the original post.

Is any of the key columns of data type CHAR in your job but VARCHAR2 in the database? If so, you may need to do some trimming.

Why should it? No other XML parser can.

Demand well-formed XML from your provider.

Field("31|28|31|30|31|30|31|31|30|31|30|31", "|", MonthFromDate(InLink.TheDate), 1) is a quick way (ignoring leap years) to get the day number of the last day of the month. You can then build the date from components. Use an If..Then..Else derivation for the list to set the last...

The answer will depend on many factors, including what other load there is on the server(s). For example you could use 10 Lookup stages and disable operator combination, so that the individual lookups are being performed in separate processes. If not much else is happening on the machine, this would...

Blocking does occur in parallel jobs, but is less apparent because inter-process row buffering is automatically ON. And the buffers are, by default, larger than in server jobs.

My understanding is that Microsoft SQL Server 2005 is not supported in version 9.1 (this is also true for the XMETA metadata repository). The others remain supported in version 9.1.

Windows 8 is not supported.

The -force option causes the installer to ignore all but the most severe errors, but there is no guarantee that the installed software will work properly.

30107 is a fairly generic error, and the issue here is when an attempt was being made to discover some information about the project. It could be something as simple as permissions on the project directory; it may be more complex, like corruption in the project's hashed files. Do you experience the ...

Is this pivoting into separate columns, or pivoting into a single column as a comma-delimited list.

There's an answer to this not very long back on DSXchange - a Search should find it.

Pivoting into a single column is most easily accomplished using a pair of stage variables.