DSXchange

You'll always need a DNS (or some other way of resolving host names to IP addresses).

Whether or not you need a DSN (data source name) is a different question.

A 32-bit checksum will be equal for different strings with a probability of about one in four million. If this is unacceptable use a different mechanism, maybe a 64-bit checksum.

No, it avoids US being confused with AUS, for example.

Try quoting the column name and the table name.

Are there any recent patches for Connector Access Service? (I can't check easily at the moment.)

The first URL is the Information Center for IBM Cognos BI version 8.4. http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp Execute a Search for "Business Glossary" - a number of links of varying usefulness will appear on the left-hand side. The second URL is the instructions for...

I would imagine that the appropriate Glossary URI would be http://hostname:9080/bg (or some subset thereof) but, presumably, you also need to configure Cognos with a user name and password. Maybe the hostname and port number are configured with separate properties. Not really my area of expertise.

None of the FTP stage types in DataStage support MPUT, as far as I am aware. The FTP stage supports transferring a stream of data, not a file. Multiple GET streams are possible, again as far as I am aware.

APT_CreateOp is the operator that creates the virtual data set (the in-memory table) against which lookups will be performed, and builds an index for it unless the source is a Lookup File Set. APT_CreateOp is one of two operators in a composite operator created by virtue of the Lookup stage in the j...

Are there carriage return or line feed characters (other than record delimiters) in the source data?

Stay with the Lookup stage. Make use of conditional lookup to determine whether an upstream lookup has succeeded or not.

Drag an output link from the stage. Right click the link and choose "Convert to Reject" from the menu.

Jayanto wrote:Post downloading the Fix, what should be the next course of action...??

Read the readme file that accompanies the fix.

Ignore everything in the error message after "timeout". Everything else is about the mechanism. The problem is in the inter-process communication (ipc) function that gets the next buffer-ful of data. It has exceeded its wait interval. Why? There are a number of possible reasons, but they u...

Another possibility is to use an ls command to detect whether there is any file matching the pattern. Exit status will be non-zero if there is no file. Use command line options on the ls command to get the most recent one to the top of the list, and capture that file name. ls -1rt home/app/test_data...