DSXchange

The 7.1 Designer has a macro (right click on a column) to propagate a common function, like TRIM, to all derivations in a link. Can save a lot of time, check it out.

You face a larger issue with a partitioned database load. On high volumes you simply cannot issue a commit at the end, as the data is independently streaming to a node. PX bypasses the coordinator node because it has the ability to read the system catalog. It automatically partitions the data to tha...

My guess is that this is not your problem. You have some mathematical expression that is using non-numeric data inside some column derivation in your transformer. Look for anything that is doing math and investigate.

Please post your derivation for appending the time

You can look into the unsupported hash file calculator utility on your DS cd written by our illustrous Ray Wurlod if you want to see exactly how to compute a minimum modulus. That's the easiest way to do it.

Oracle is fully supported using the Oracle client connectivity software supplied by Oracle. Your Oracle admins should be able to help you on this. SQL-Server is supported using the ODBC drivers installed with DataStage. DB2 is handled the same way. There is a lot of installation/configuration docume...

All databases have some ability to high-performance load data, some databases have some ability to high-performance extract data. I recommend you explore using the appropriate utilities for high-performance loading in SQL-Server. The design you have described is the simplest one possible, but is oft...

Search the forum for "SETFILE"

No. You must rework your job. Row buffering and caching defeat your need to have committed data after each row is processed.

You have to write your own. One does not exist. Search the forum, I posted a DS BASIC function that does what you need, look for keyword INLIST.

By the way, you can look at Yahoo's message board for ASCL stock, as these price ranges are discussed there quite often. There is no published price list, as this software is often bundled with consulting services, maintenance, etc.

There's a saying, if you have to ask, you can't afford it. The price tag ranges on how much of the product set you buy and the configuration (how many cpus, etc). A rough range is from 100K DS only (Server) on a small server to up to 500K for the Enterprise suite on a large server/cluster.

I've seen this when the OCI stage using a version of Oracle client that is not the same version as the database. In other words, you're using an OCI8 stage to connect with 8i sqlnet pointing at an Oracle 9i installation. Unexpected errors may not be covered and cause weird results. Just doublecheck ...

Since you are recreating the hash file every run, you've got a lot of options. This is a good thing. If your hash file is of the type YNAMIC, then what you want to do is set the minimum modulus at a high watermark so that you don't waste time everyday growing it up to the size it typically needs to ...

I have no idea what you are talking about. Could you please post a description of your job designs. If you have a reference lookup, then describe your job something like this: I have a transformer reading from an ODBC stage, referencing a hash file and writing to another ODBC stage. A column is reje...