DSXchange

OK, if you use those you will need to update. I prefer not to. Usually the "when" doesn't matter, in my experience.

Are you certain that no other process adds 100 rows between when you run the query in SQL server and when you run it in DataStage?

Think of it like this: What you specify as "key" in the Transformer stage means "search key" rather than "primary key". If you're using a Hashed File stage, you can only search on the entire primary key because that is the way that stage type works. But if you're using a UniVerse stage, you end up u...

The command's output is wherever the command sends it. You can use redirection operators such as > or >> to direct it to anywhere you require. By default, output is to the current working directory which, for DataStage processes, is the project directory.

Contemplate adding a "run number" or timestamp to the target table. This will make unwinding any committed rows straightforward, albeit through another transaction for the DELETE statement.

Need some urgent help Regarding Range Lookup..

Then sign up with your support provider for premium service; learn the true cost of urgency. We don't do "urgent". We're all volunteers.

Within the one Transformer stage you can invoke a before-stage subroutine that initializes variables, opens files, and so on. In any expression within the Transformer stage you can invoke Routines whose type is "transform function". Within the same Transformer stage you can invoke an after-stage sub...

How about telling us what solution you DO want?

Things are tighter in 7.5.1. To correct the metadata mismatches all you have to do is to make sure that the table definition in your job exactly matches that of the table in the database. The easiest way to do this is to import the table definition and load it into your job; in 7.5.1 you will not, i...

There has been no official announcement from Ascential stating that Server edition is to be phased out. Certainly there is currently less development there than in other parts of the suite, but Server edition is a much more mature product, and really needs maintenance rather than development. This i...

You may be able to retrieve RT_BP47/JOB.169454777.DT.1373252191.TRANS1 from the server machine using FTP. Somewhere an attempt is made to perform arithmetic. This is the only situation where this message can arise. That should narrow your search more than somewhat. Expressions in a Transformer stage...

Basically no. What you've got is a file that does not comply with the published standards. You can get around it, but the technique is not escaping particular characters (which you'd have to do before DataStage reads the file based on metadata). Unless, of course, you pre-processed the file with a D...

Search the forum for SETFILE to learn how to set a VOC pointer to a hashed file created in a directory, or you can use one of Chuck's tools from his website.

Most operating systems also have a chap (change priority) command (renice by another name), which is also available from TCL (as the CHAP command). So, for example, you could use ExecTCL as a before-job and before-stage subroutine to execute the command CHAP DOWN which lowers the execution priority ...

A Type 2 SCD should never need to UPDATE - you are always going to generate a new surrogate key value, and therefore you are always going to INSERT. In loading dimension tables you need two tests. The first is existence - does the key value already exist in the target table? For this to work you nee...