DSXchange

looks like a nice relational implementation.....nested perfectly, unless I read it incorrectly. THis should be working just fine with aggregate and something in notes as your key.

if not...what "are" you getting?

read...then re-read the post and the link I gave you up above. Yes...you must use lookup, preferably a sparse one if you anticipate any changes in the data.

I can't be sure, but if it's an EE Job it might be because you aren't using a sparse lookup.....check out this entry... http://dsrealtime.wordpress.com/2010/05/26/guidelines-for-publishing-services-with-datastage-and-qualitystage/ ....you must make sure that your WISDinput link is the driving link f...

FastTrack can be configured to generate 7.5 Jobs as .dsx's.

Ernie

hmmm. Tell us more about the Job. If you choose to use them, you can have only ONE wisdInput or wisdOutput......please explain what you mean by "6 outputs"...... Make absolutely certain that your wisdOutput stage always receives a row of "something"...just for this reason -- so t...

You get it from the same place in "that" Information Server as you do from your "current" Information Server... Have you logged into the Information Server Web Console for your current environment? Your "other" Info Server environment has an equivalent Web Console....it...

An ISD Service is owned by the Information Server domain. Assuming you have another Information Server in the test environment, you could migrate the ds job and the isd application metadata and deploy it there......but it has to be another fully operable Information Server instance, with DataStage, ...

I'd like to suggest that you start a new thread, or change the status of this....there is nothing to "work-around" here...just techniques and features that have to be learned. Disable is at the deployment workspace of the Information Server Console. Use the Edit button on the lower right a...

Well..it's fairly simple, assuming you know how to do a pivot in DS, and have spent time with the xml best practices and know how to combine mlutiple chunks of independent repeating nodes... Nail those two tricks and the final document construction will be not too bad.

Tough call.... is this the full extent of the xml you need to create, or just a tiny sample of one that has vastly more columns and "types" ? It's not that great an xml design.....too bad that the AID, BID and CID fields aren't just true element names instead of attribute values. Do you ha...

Yes! Yes! and Yes....right up until the suggestion of C and .NET. ETL enhances the ability to achieve all of these great goals......other languages leave those goals at arms length.

Assuming that items are "beneath" customers or orders, then check the aggregation ootion and make item or something at its level a key and the grouping will happen automatically.

Sybase Open Client (OC) = a stage that uses Sybase's own native API.

Ray --- "separate products"? ....that's not really true once release 6 came out....they are very much a hybrid.....the concepts of DataStage were placed onto the vastly different and mostly command line interface for Torrent....at the pure engine level they are separate, but the GUI constr...

Not for ISD........the starting and stopping is controlled entirely by the gui....a command line is coming in the next release as an extension of istool......

Indeed, for always-on MQ type jobs, you can have it read a special message type to shut down gracefully....

Ernie