DSXchange

Pretty sure as the name implies they are only leveraged when doing "upserts" in the stage... "insert else update" or the reverse.

Not asking if you are using any 'special' settings, just how you have it configured. What options are you using in the Connector - are you automatically generating the SQL? What write mode are you using? Etcetera etcetera. And still wondering what commit level it is actually using then that option i...

You may already know this but hashed files can be copied easily provided one of two conditions are met: 1. They are 'pathed' hashed files, meaning were not created in an account 2. Your account-based hashed files already exist in the target location New account-based hashed files would not be found ...

Normally you would set the Record Count to zero to accomplish that. With it disabled, any idea what it is actually using when the job runs? I haven't been able to find any reference material online as of yet that discusses this situation. What settings are you using in the Connector?

Stage Variables : svValue : if svKey = Input.Key then svValueOld:':':Input.Value else Input.Value svKey : Input.Key svValueOld : svValue You only need two as there's no need to save the 'old' value, just the key: svValue: if Input.Key = svKeyOld then svValue:':':Input.Value else Input.Value svKeyOl...

You would use Transformer Looping to go the other direction, columns to rows. This is transformer concatenation and Remove Duplicates, retaining the last duplicate. Edited to clarify the fact that by 'aggregation' I meant aggregate the values in the transformer via concatenation, not the stage of th...

Contact your official support provider. That 'solution' seems a little... ridiculous. Also do an exact search here for "Parallel job reports failure (code 11)" and see if any of the other matches help.

Since they're not numbered (as in Oracle) you have to realize that only columns marked as Key columns get used in the 'where' clause. Guessing yours isn't.

jonesv wrote:I will check Mr. Bland's site for his utility

He released the code here in the post I linked to. And several more, if I recall correctly, which a search by author could turn up. Not sure he maintains his site any longer nor allows any new access.

Sure... if I had access to DataStage.

Now I am forced to rely on the kindness of strangers.

However, couldn't those "purge settings" match the default? Just trying to clarify the difference between them being non-default and actually different. Perhaps that's not an issue if all you care about are which ones have been 'overridden'.

There are some utilities that Ken Bland posted once upon a time, some of which deal with purge settings. See if this helps or at least gets you a good starting point.

Yes. Yes it does. <shudder>

I do not recommend changing it on a lark. I like lark. Especially their tongues. In aspic. Sorry, first thing that popped into my head after reading that line. <goes back to eating his popcorn and enjoying the movie Andy is filming> Actually, a real question - I remember P and T but what's R again?...

I've done something very much like this in Server many moons ago. It also involved an internally generated sequencing value to help group things (perhaps even two? inner and outer?) and then a custom Sort collating sequence to get the internal records per group in the correct order. Perhaps that las...