DSXchange

It marks the column with red and the compilation fails with the error message : A dimension update column REC_LOAD_DT does not have a derivation!

I realise I could override Update and Insert statements in the target Oracle connector, i.e. drop the REC_LOAD_DT column from the update statement,
but I was wondering whether I could handle it someone in SCD stage instead and use the generated upsert in the Ora connector.

The problem is that the only Pupose Code I could use here is Type 1, or <blank>. Together with setting derivation to sysdate (or in my case BATCH_DATE) it does not achieve my goal, i.e. leaving REC_LOAD_DT as it is.

I am trying to build Type 1 dimension using SCD stage. The definition out the Update link contains the following columns, with their SCD purpose codes and derivations: Derivation Column Name Purpose NextSurrogateKey() REC_KEY Surrogate Key lnk_In.REC_IDNT REC_IDNT Business Key lnk_In.REC_DESC REC_DE...

Hi, I'm using SCD stage for the first time (previously I used Change Capture and Transformer to implement dimensions load). I am on version 8.5 with FP1 installed and having problem with disappearing connection parameters when I'm definining the DB seduence to be used for for generation of Surrogate...

Hm, if this is the correct behaviour then it is not what I'm looking for - at the moment I'm loading 20000 records rather than 10000. I still would like to know whether I can just "split" rows between two processing nodes, so they are loaded faster. In the future this job needs to be able ...

I am having troubles with configuring parallel read in Oracle connector. The entire data is read twice - once per each node. Firstly, my source table is not partitioned in any way. My understanding is that I still should be able to read the data in parallel. I havce configured the Oracle connector i...

Just to close this topic off. It turned out that after I have installed FixPack 1 patch it all started to work.

Thanks. It looks like I can call DSSetUserStatus in the routine, so it's fine.
I just thought (and I was wrong!) that I should be able to see the in Repository.

We have a new installation of Datastage 8.5 and I would like to be able to use some DS routines, for example DSSetUserStatus, but I can only find a handful of DS routines, rather than a full set decribed here: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.ds.cliapi....

Wrap it in Code tags.

I first thought it was a solution to my dataset/schema problem

James,
File sets work perfectly. Thanks for the suggestion!!

Never used them and not sure what they are, but will try to find out.

Would you be able to point me to where I can read about it please. A generic heading will do.
Thanks!

evee1 wrote: SeqFile --> ColumnImport -> Transformer --> Dataset
\
\--> SeqFileOut

Oops! The link to SeqFileOut should start in the Transformer stage.

I was wondering whether I can somehow use a schema to define the input from a data set. I was planning to use data sets to pass the data between my jobs, as the documentation suggests "using data sets wisely can be key to good performance in a set of linked jobs". However I can't find in t...

Hi Andy, What did you end up doing? I have a similar issue. I'm implementing a generic sequence to cater for various steps of file validation. One of them is a routine that verifies the total of a given source field in a file against the total given in a footer. I need to pass the result of a valida...