DSXchange

Hi folks, currently we populate MW using the DataStage Connector Import Wizard. The orange database tables are created in MW automatically when we use this method to import Table Defs (blue) into DataStage. So this approach gets us set up nicely in the development environment. Our current plan is to...

You can use a lookup stage to do a range lookup.

Hi folks, I am told that the modulus partitioning strategy is the same as hash if the hash key happens to be an integer. So in this special case, perhaps specifying modulus partitioned reads in the Oracle Connector will map directly to a hash partition in DataStage. I have not checked it.

Hi folks this appears to be a Solaris thing. IBM recommends doubling memory estimates for the Solaris platform.

Thanks Ross.

in 8.1 there is a new environment variable which controls this and in 8.5 the behaviour is default. In 8.1 in order to use it you will need to add a copy prior to the write of a dataset and read of a dataset to allow for a modify adapter (so you cannot optimize out the copy). Great post but I have ...

Hi folks, is there a way to reduce the 30MB used per process? This seems like a huge amount of memory. It would be nice to get this down to 10K or so.

Thanks,
Doug

Okay I am adding the "will partition despite the preserve-partitioning flag" warning to my message handler.

Goodbye partitioning flag. Maybe you will be fixed someday.

Clear the preserve partitioning flag on the stages upstream on the input links to the Lookup stage. Use Entire partitioning on the reference input link unless you can be 100% certain that the stream input link uses identical Hash partitioning propagated from upstream by Same. Hi Ray, thanks. As I s...

Hi folks, I have a lookup stage doing nothing fancy. The stream link is set to SAME. The reference link is set to HASH. Both links have the preserve partitioning flag set to CLEAR. I still get the warning. Just for grins, I also cleared the flag on the lookup output . Still get the warning. Ideas? D...

Make sure the column on your join input and output links says Nullable=Yes.

Use sqlplus?

Hi folks, I am using the OracleConnectorPX stage to bulk load into an Oracle table. This morning I starting digging for details in the help about how this stage is working and I stumbled upon the "Oracle OCI Stages." What is the difference between these and the OracleConnectorPX? Are they ...

Found the problem. One of the input links (not output) to the join had Nullable set to no. Not sure why this would affect the output, but whatever.

Sorry for the bandwidth.

Doug

Hi folks, I have a transformer stage after a bunch of left outer joins in order to apply null defaults. This is typical. Each column in the transformer has a NullToValue call. Unfortunately it rarely works. The problem appears to be that DataStage join does not populate fields with data that NullToV...