DSXchange

When's the interview? Architecture of which version? You can learn about the architecture - and various possible topologies - from the IBM InfoSphere Information Center.

DataStage is not a reporting tool.

Every version has release notes. They are available from IBM's web site.

The UNIX style line terminator is the one used in the UNIX operating system while the DOS style line terminator is the one used in the Windows operating system (DOS). A UNIX line terminator consists of a single character, namely a linefeed, while a DOS line terminator consists of two characters, nam...

What do YOU understand by the metadata mismatch on scale? Scale in the context of a timestamp defines the granularity of fractional seconds. A metadata mismatch is where the column definition in the table is not the same as the column definition in your DataStage job. These things are checked at run...

Depends. What is your definition of "numeric"? Does it include all of the following? 24 17.32 -8.92 6.023E23 -1.551E-15 You can use an appropriate testing function, perhaps Num() to determine whether the string (note, not "sting") is numeric based on your rules, within an If..The...

Create a Sequence. Use an Execute Command activity to determine which files have been uploaded. Use Nested Condition activities to determine whether to run jobs. Use Job activities triggered by these to run the jobs. Construct in a loop or not, as is convenient (see previous posts on this thread).

Welcome aboard. But datastage wont support oracle 8i. That assertion is not correct. DataStage is simply another client application as far as Oracle is concerned. So, to talk to Oracle 8i, all DataStage needs is for the Oracle 8i client to be installed. The ODBC driver, in turn, sits atop the Oracle...

Sounds like you may be generating a deadlock, with the same key on more than one link into the target. How are your array size and commit levels set?

Or you could take yourself to Fix Central and browse the available patches for your version and platform.

Save Ernie doing the work for you.

Please verify that all of the following directories exist and, if they do, that the executing user has permission to access them.
/apps
/apps/opt
/apps/opt/aedw
/apps/opt/aedw/staging1
/apps/opt/aedw/staging1/CSR

Actually, from what I understand, while the 8.x release does an "itag installation" it does not support having multiple versions installed on the same server. Unlike previous releases, it is "one and done" on any given box. Unless, as you're thinking, this is now possible. Be cu...

Also make sure that you have used the appropriate bind utility (probably bind22) on the DB2 client (that is, the DataStage server).

Mounting the remote directory (that contains the files) on the local system is supported.

Yes, you can configure the ODBC driver for text files to access a remote "server".

Or you could use a loop, but still need a Nested Condition activity within the loop to determine whether the source file exists - perhaps in conjunction with an Execute Command activity to perform the actual search.

anbu wrote:Load CSV file into hash file. Use the hash file for lookup

It's hashed file, not hash file.