DSXchange

You can not estimate time without knowing how large the rows are and whether there are other factors influencing throughput such as network bandwidth, number of Oracle listeners, parallelism within the query, other locking operations on the target table and so on. This is a "how long is a piece of s...

Not directly. You have control over the number of rows per transaction but to implement the rest you would have to design it in. You would need to keep a count of how many rows had been loaded, and build in restart logic (perhaps driven from a job parameter) to start from that point. It can be done,...

Of course.
You may need to decide exactly how you want to partition the data to the multiple flat files, rather than relying on one of the PX partitioning algorithms.
Otherwise, simply write to multiple Sequential File stages.

You should be able to detect within DataStage that the write has failed, and capture the row that failed to be inserted (read about reject links).

What makes "them" think that the second INSERT would succeed when the first INSERT had failed?

Lots of neat ways but they all boil down to pretty much the same thing; park it on disk. Another output link writing to a text file or a hashed file. The job's user status area isn't in memory, it's a field in one of the run time hashed files in the Repository. So any "neat" solution using the user ...

Your original problem was casing. Function names are case sensitive.
The function name you wanted was DSAttachJob. The function name you specified was DSAttachjob. Not the same function.

So, to keep all the alphanumerics, use that result and convert to "".

Red Brick 6.30 is the current version. Red Brick 6.40 is almost ready for beta testing. Design for releases beyond that is under way. If they're continuing to develop it, is it likely that they'll drop support for it? Don't automatically accept anything sales dudes tell you. Oblige them to find out,...

Think about the amount of work you're asking DataStage to do. How many rows are selected by this query? SELECT ... FROM FACT WHERE CAPTR_DT = (SELECT MAX(CAPTR_DT) FROM MONTH_CONTROL) How many rows are selected by this query? SELECT ... FROM FACT then doing a lookup for every row wit...

It makes more sense not to use the Sequential File stage, for performance if nothing else. You can generate the surrogate key within the Transformer stage, perhaps in a stage variable, then use this as the value of the primary key of the one table and the foreign key of the other table. If you use a...

Do you understand why?

I believe it would be relatively straightforward. What Siva is postulating is switching from one bulk-loading stage type to a different bulk-loading stage type. There's much less difference between bulk loaders than there is between database servers. Hopefully the DB2 bulk loader stage handles dates...

DataStage clients use OLE (object linking and embedding) to access objects exposed in a number of OLE servers, among them dsobjects.dll. In order to understand this mechanism, and the errors it can generate, you really do need to have studied some form of Windows programming using OLE. The bad news ...

It is necessary to have temp space because some files are compressed on the CD; the CD being read-only means they can't be uncompressed there!

Also make sure that the Oracle 32-bit libraries are mentioned ahead of the Oracle 64-bit libraries.
It also helps to set in dsenv.