DSXchange

We are building a data warehouse. We have Slowly Changing Dimension jobs that write to three (two if Type 1 SCD) sequential files: Type II SCD: If record has Type 1 Change - write to 'Type 1 Update' file (to update all records by Natural Key) If record has Type 2 Change - write to 'Type 2 Update' fi...

Yes, but is there a way to do this without altering the composure of the sequencer job (without adding Sequencer stages to collect links with Any)?

We have a "master" sequencer that executes some jobs and bunches of other (nested) Sequencers. Our issue is that we want to (in Autosys terms) "ice" various jobs on occasion. By "ice", I mean: don't execute the activity, but evaluate (trigger) to "OK" so that ...

Is there a way to compile all Routines in a Project?

...similar to the Multiple Job Compile, but for Routines?


TIA,

Rick

DSXers, I am loading a table with a unique (surrogate) key. We have a hash file that maintains the the MAX() surrogate key for each table. For all new records, the key values are generated in a link variable which uses the MAX() surrogate key from the hash and @INROWNUM: SurrogateKey = HashMaxKeyLoo...

DSP.Close Error -100 in $DSP.Close Any ideas on this error message? Server job that writes to an OCI 9i stage. Array size is 50, commit interval is 10,000. The other interesting thing to note is that each input record is assigned a unique/primary key value (surrogate key) using @INROWNUM. This is a...

We are currently using the Oracle 9i client and accessing 8i and 9i databases. We have recently been asked to extract data from an Oracle 7 database. First, a general question. Can DataStage access two Oracle homes simultaneously? Or, can we use the OCI8 and OCI9 stages within the same project? Perh...

Just a note to future users and FYI...

I had to use @FM in DS 7x (Linux RH AS 3.0) to get this to work. @VM would not work correctly in the locate function.

Thanks for all of the great info. We are just staring the construction stage of an Enterprise DW and these posts are invaluable. I am testing this as a solution for Type II Slowly Changing Dimension surrogate key lookups (in conjunction with Mr. Bland's routine) and have one question... Is there a m...

Experts, We are trying to determine the best approach for organizing the metadata within DataStage. Our environment uses Oracle tables, sequential flat files, and hash files. Any table or file can act as a source and/or target. We have several development initiatives that may share a table definitio...