DSXchange

Can't be done in one job. You'll need to do the extraction in one and then only run the second truncate-and-load conditionally on the first job actually producing output.

Ok... well then, go ahead. :wink:

Seriously - what have you tried so far? You did try before you posted something here, right? Give it a shot and try searching the forum as well, this is hardly a new concept.

Lastly, if you get stumped, click on the little winky man above for a 'spoiler'.

Read Only jobs move just fine. You do have to do this from the Manager and not the Director, btw. Should work from the Designer as well but I generally avoid using it for maintenance tasks like this.

Now if Ray were here, we'd get something like:

It snot wrking? Let me get you a hanky!

Platforms are always susceptable to their own little quirks, but in general a UNIX to UNIX move like that should be painless. Install on AIX, export all project from the HP box and import them on AIX. I've done UNIX to NT and there's more pain involved in that one. Of course there's things like supp...

Definitely on the plate for sometime today, assuming it finishes. At this point I have no idea where the overhead is here - in the actual writing of the XML or the looking upping of the big chunks. Or both.

Ay, it will.

Just spent the last three (long) days taking my first foray into the Wonderful World of DataStage and XML. Working from an Ascential 'Best Practices' guide we built all of the optional pieces as XML 'chunks' written to hashed files via the XML Output stage. Building all of the chunks was not a big d...

More points that way.

Apparently, DataStage Enterprise Edition as DataStage Extended Edition is abbreviated as 'DSXE'.

Sure, that should work fine. Now, that's a Server job answer as you marked the post as Server.

Can't provide specific help without alot more information. I'm assuming there is custom (user defined) sql involved as that is typically the only way to get this error - and it typically involves a mis-match between the number of columns defined in the Columns tab, the number of fields returned by t...

My problem is i would like to have two conditional triggers (i.e links )from A and b to C ,which it is not taking. There's no reason why this would "not take" from the information you've posted. A Job Activity stage cannot have multiple inputs, which is where the Sequencer stage comes in as it can ...

Mode rounds excess digits if 0 or not specified, truncates if non-zero.

Curious if you read the online help for the Fix function? With no options it rounds to a default precision of four - and you want zero. Plus, what you want is not strictly 'rounding' as rounding would take 2.9 up to 3 but would also take 2.1 down to 2. You need to play the old game of adding .5 to t...

Never said it would be fast, Vincent.