DSXchange

Please make Craig's point to whomever gave you this "requirement", and suggest that they read the Data Warehouse Lifecycle Toolkit by Ralph Kimball and others in order to learn about what the various types of slowly changing dimensions actually are. For they seem not to understand the concept. Let u...

UniVerse allows accounts to be created in various different "flavors" to emulate different origin systems more closely. DataStage always creates accounts as IDEAL flavor, therefore you will never have PI/open flavor. You can force the Routine to compile and run in PI/open flavor using the compiler d...

It's sufficient to LIST DICT RT_LOG (without a numeric suffix) because RT_LOG is the generic file dictionary for all DataStage job log tables.
Yet another example of one of the weird things that UniVerse can do - a table definition with no table!

Depending on what version you have, you may have available a so-called Intelligent Assistant that will create these migration jobs for you. You will need to have imported the table definition previously.

Don't forget to check that the day and month are valid for the new year. For example, subtracting one year from 2004-02-29 should not return 2003-02-29 because this is not a valid date. What it should return you will need to decide, and then document as a business rule (in the long description of th...

Read Chapter 2 of the Parallel Job Developer's Guide (parjdev.pdf), which explains pipeline and partition parallelism. The IPC stage (or row buffering) in server jobs achieves pipeline parallelism. Multi-instance running, Link Partitioner stage and multiple streams within a job are ways to implement...

The obvious suggestion is an aberrant row (number 3700001?) with the wrong number of columns - perhaps because of a delimiter character appearing within the data.

To invoke a stored procedure from DataStage you must first import the stored procedure definition. If DataStage objects to the import process, then the stored procedure is not amenable to DataStage's method of operation (it must process a record set).
See also this post

That is the truth!!!

You can configure the client software (or ODBC driver) with filters that limit what is retrieved to the smallest reasonable set of table names.

Instead of SYSCOM (which hails from Prime INFORMATION (ancient history)), you need UNIVERSE.INCLUDE. Also, prefer FILEINFO.H to FILEINFO.INS.IBAS (same origin).

Fosters market a beer called VB (Victoria Bitter). You're as likely to get a VB answer there as here. DataStage is not written in, and does not use, Visual Basic. Are you confusing DataStage with Microsoft's DTS (data transformation services)?

A small clarification to Arnd's first post. LEN(TheString) returns the number of characters in TheString. BYTELEN(TheString) returns the number of bytes in TheString. LENDP(TheString) returns the number of display postions required for TheString. For example, consider a string comprising two single-...

That would seem to be a logical conclusion. Currently I have no way to verify it. Get in touch with your support provider, who may be able to source the 9.1 adapter for you.

Director includes a "print to file" capability. Select the required events from Log view then choose Print from the Project menu. Check the "print to file" check box and you will get a common file dialog.

Welcome aboard! :D There is an overlap, result of Ascential's acquisitions of multiple sources of technology. AuditStage was originally a product called Quality Manager, which was acquired when VMARK merged with UniData to form Ardent Software. ProfileStage was originally a product called MetaRecon,...