DSXchange

Reporting Assistant was deprecated in version 5.2. However, jobs should be able to be moved to the reporting database. Are you certain you had the Jobs check box selected during the Update phase? Note also that Reporting Assistant does not work reliably with job sequences, shared containers or (in s...

This technology combination is relatively new, which means that probably the only source of documentation is IBM via your support provider.

No, I meant generated SQL.

I suspect that this, too, would be erased when you open the builder.

Therefore I have no answer to suggest.

Does your support provider have a solution?

The values with which the hashed file is created are on the Options tab of the Hashed File or UniVerse stage. Subsequently you can use an ANALYZE.FILE command to determine the current settings. Use the Hashed File Calculator to recommend an appropriate setting. This may be a case where a static hash...

The largest integer supported (BigInt) has 18 digits. You will need to read this field as X(20).

As noted earlier, DataStage (nor any other client tool) is unable to create the workbook itself. The workbook and the worksheet within it must exist, and the column headings must exist in the worksheet. This, basically, is what the error message is telling you. The column names in your job design, n...

To find duplicates in the source stream you must check within the Transformer stage (using stage variables). There is no other choice without changing your job design.

Fixed with implies no column delimiter at all. NUL occupies one byte. Therefore your proposed approach is not generically valid.

Read each line as a single VarChar column and parse it within a Transformer stage.

Getting it right first time would have obviated this new requirement. Now you have to fix the expiration dates. As Craig suggested, write out the rules in English (or your native language), and turn this into a source-to-target mapping specification. You will probably find that it comes out easily. ...

Write out your processing specification (what is to happen in all cases) in English. You will find that this guides your thoughts. For example, the generic Type 2 SCD needs to make two choices. Therefore there are two IF tests in the following pseudo code. If (row exists in target table) The...

Cool.

No idea. Can you use another client (maybe MS Access) to insert rows via an ODBC connection?

You can run the jobs out of different projects on the same server. That way each project has its own independent storage of environment variables.