DSXchange

Sorry, no hijacking of old posts allowed... so off you go to your brand spanking new one.

Sorry fmou, just have to make a comment on your "(ironically)" comment. It might seem a little bass-ackwards at first but realize that when the stage reads a file it outputs the result from the stage. Conversely, to write to a file you need to send your data as input to the stage, which it...

Just wanted to make sure as it didn't seem like that was the case from your previous posts.

Billyqing wrote:It looks that I will use Infosphere CDC and CDD to handle all delta changes and put those into the target.

Infosphere CDC? So your company has purchased that?

Note also you typically do one or the other for a particular source, 'or' not 'and'.

It's not a conditional lookup, it's a range lookup. Have you tried using that specific option?

OK, so I'll take the bullet... why the quotes, Ray? :wink: While Left() and Right() would work to split something into two pieces, they did say there were four columns although the example only showed two. You obviously can't use Field() when there's nothing to delimit the fields in the string but f...

The first question typically would be: you can't compile any job with a Transformer stage or just this one? From the error, I say it is the former: Output from subprocess: /opt/SUNWspro/bin/CC: not found It can't find your C++ compiler. You need to have a supported compiler installed and configured ...

What database are we talking about? And are you saying you are loading a parent table where child tables are getting locks or vice-versa? FWIW, I don't see a 'self lookup' as being any kind of an issue here.

Perhaps you need to think about leveraging a surrogate key for this?

You should be editing .odbc.ini in $DSHOME and uvodbc.config in each Project directory where it will be used.

Or take the one available freely here and adapt it... can't imagine it would need much if any changes.

A "checksum" is not an encyption mechanism since there is no decryption side to it and it will not generate anything "distinct and uniq"... and you don't have any choice on the length of the output. Sounds like you need to look into other methodologies like MD5 and others.

Sorry, but isn't the error message clear enough?

Cannot insert duplicate key row in object 'dbo.DW_Root' with unique index 'IDX_Site_Code'

Post your actual error(s).

I'm assuming that you either don't have execute grants for the connecting user or you need to qualify the name of the procedure.