DSXchange

You're wrong about the KeyMgmt routines. If you've used them exclusively to populate the target, there's no issue. If late to the game, just start it off high enough to avoid any existing keys.

Best of luck, let us know how that turns out, good or bad please!

You need to capture the MAX() value outside the job and pass it in, then increment the job parameter for each record. That or use one of the 'KeyMgmt' routines that come with the tool.

Since we just went through this recently with someone else, here's one I knew I could find. As noted, there are other examples out there.

viewtopic.php?t=136037

It has been mentioned here quite a bit, so do an exact search for "vertical pivot" and troll through what comes up. Yes, you will find a lot of matches to posts with this exact same advice to search in them, keep on going and you'll (eventually) find the wheat amongst the chaff.

Perhaps Ernie will come along with a better idea. All I can think of at the moment is to read the XML file in using the External Source and XML Input stages to 'flatten' it and then in the same stream use an XML Output (or perhaps XML Transformer) to turn it right back into the same XML without any ...

First thing to understand is that while "processor" is a physical concept, an actual discrete piece of hardware in your system, a "node" is nothing more than a logical concept and has no direct relationship with CPUs. Its just another process that your server needs to run and you...

Cool. Luckily for the rest of us, that LDR_CNTRL issue is specific to AIX from what I recall.

Did you set the Stored Procedure stage to "Transform" mode?

Me, I don't understand... hence I'm waiting for the OP to come back and clarify things. Again.

Sai, re-read cuckoo's last post. I edited it slightly for clarity and to emphasis the points they were trying to make.

One technique that gets mentioned here uses a pair of converts, like so: Convert(Convert('ABCDEFGHIJKLMNOPQRSTUVWXZY0123456789','',YourField),'',YourField) This would remove everything except numbers and upper-case letters. If you have the need, you could add the lower-case alphabet to the mix as we...

There's nothing "special" about any of those characters, that is why people are asking you to clarify - be specific - about what you mean by special, what exact list of characters you want to remove. Regardless, Convert() is the resolution, not any kind of a 'workaround'. If you still need...

I don't have any docs access right now... what other options are there for File Block Size besides 'system picked'? And there's nothing like a "cache" option?

You didn't answer the key question - is your source XML formatted? (AKA 'pretty printed') That will make this exercise more... difficult... if it is anything other than one big long record. And I suspect it is if you are reading it with the Sequential File stage.