DSXchange

nelc, Another way to transform this type of date/time would be to use the supplied routine - DateTimeStampToOraOCIWithTime This is part of the sdk and you're keeping things standard from the standpoint that if someone were to look at your job they would instantly know what kind of date/time you were...

I recently received some strange output in the director log from a simple sort job. The job is sorting 43k rows and the sort is very simple - one column and ascending. The following are the "odd" lines - Sort_Into_Order: GetInRow (10000 rows, 1073888624 seconds) Sort_Into_Order: Sort (1000...

Thank you all! I figured out how to do this and corrected my original post and deleted my subsequent post There is much for me to learn about posting and authoring posts!

There are actually two files that need to be correct in order for your ODBC connection to work. These two files are listed below - (depending on your version of DS) .odbc.ini in Ascential/DataStage/DSEngine and uvodbc.config in Ascential/DataStage/DSEngine or uvodbc.config in each of the project dir...

Sanjay, First, have you verified that dsrpcd is running? perform the following from Unix - ps -ef | grep dsrpc This should return something like - root 26986 1 0 Apr 16 ? :00 /datastage/Ascential/DataStage/DSEngine/bin/dsrpcd Second, If this is not present then have you tried to ping the Unix server...

Most version control packages work from Delta's between the files that are checked in and what already exists. Most customers use, succesfully I might add, apps like PVCS and maintain version control based on the .dsx supplied. These tools do not understand how DataStage works nor should they. It sh...

If you are attempting to read complex data such as this I would suggest that you use the cff or complex flat file stage. This stage will do everything you require and there is sufficient online help and documentation to help you along the way. It would be difficult to use the sequential stage to rep...

You could also use the Link Partitioner stage (active stage) if you are at a version of DS that supports it. This will allow you to specify up to 64 output links. You can also choose the method (round robin, hash etc...) partition the incoming data. You could then use the Link Collector (active stag...

One of the best ways to retrieve the current nextval or skey from the target db is to have a job prior to the load execute the following sql against the table you will be loading - SELECT MAX(nextval) FROM {table} If the job is defined as having only one column and you have set up the job to execute...

It is unreasonable to believe that an entire warehouse would be loaded from "memory" and never drop data along the way. In all successful projects the data MUST be staged at various points along the path. The trick is to determine when and how much to stage. A good model would be to extrac...