DSXchange

Moderator: please move to QualityStage forum

How - and when (at what revision) - was this Match Specification created?

If, by "primary contraints", you mean "primary key constraints", could I counsel in the strongest possible terms not to do that? Foreign key and check constraints, OK, but not primary key constraints. It's just too dangerous.

It has the same effect as WHERE (1 = 0) - it can never select anything.

It could be deliberate, simply to test that Oracle is up and running, but its specificity suggests otherwise. My guess is an incorrect design.

Who's going/planning to go/not going to IOD EMEA 2010 in Rome in May?

Premium membership will allow you to view the entire contents, and receive other benefits too.

Meanwhile, spend some time investigating what the Data Set Management tool can show you about segment files.

The score shows precisely what will be executed. This is not necessarily the same as what was designed, though it will be functionally equivalent. The only purpose of APT_DUMP_SCORE is to have the score dumped into the job log. Without it, the score is only distributed to section leader processes. N...

And please post the column definition from Oracle describe and the column definition used in DataStage. Have you tried re-importing the table definition to see whether it's the same?

Installation and Upgrade guide for Information Server?

Since this is a time- (date-) variant quantity, I'd recommend calculating the hours separately from the job and passing it as a job parameter value. Perhaps you could interrogate the TZ environment variable. Even better would be to have a daylight saving flag in a time dimension table, or in a relat...

Looks like you're using non-standard port numbers, possibly because you have multiple installations. Please determine the port numbers of:
(a) the Information Server listener
(b) the DataStage RPC daemon
Plug these into your dsjob command as the -domain and -host arguments respectively.

Looks like you need a solution using a Join stage, then.

There may be some announcement at the IOD EMEA 2010 conference in Rome in May.

You can't. But you can store the authentication information in a file and use that file via the -file option.

SDKSequences is always an account-based hashed file, so this edit will be beneficial.