DSXchange

Worth a shot, too!

Welcome. :D That sounds like a Windows ocx/dll/yada yada problem. First thing I'd suggest you try is to reinstall the client software. Go ahead and just run it in again right over the top of the existing installation. Let us know if that helps. I'm assuming this is only an issue for you on your PC, ...

We really should have a better picture of your job to give you a proper answer. Wrap your ascii art in 'code' tags so that spacing is preserved. Make liberal use of the 'Preview' function to ensure it all lines up properly. Keep at it until you get something usable.

Then we can talk.

No. Just commenting on the forum you posted this in - the one dedicated to questions on 'real time' or RTI Enabled jobs.

Best to abandon this and repost this in the proper forum.

Sure, go ahead.

Is there a question here you meant to ask?

Worry about the sorting, not the aggregating. The Aggregator will only need enough memory to hold a single 'sort group' at a time if you've properly presorted the data and asserted the sort order in the Aggregator. I wouldn't consider using the DataStage sort stage for this volume unless you've got ...

And you are doing this in an RTI Enabled / SOA job?

Be more specific. Are you referring to leveraging an Oracle sequence object, the kind of thing you would 'select x.nextval from dual' to use?

If so, why not just use the Surrogate Key Generator stage?

kenstorm wrote:Your next question would then be, why can't you just use Cybermation to run Hyperion reports? Good question! I will ask to see if this a possibility.

Exactly right, that would have been the next question!

Anything you can script, DataStage can 'launch'. Two primary ways: from a Sequence job the Execute Command stage would do the trick, or it could be done before/after a Server job using ExecDOS or ExecSH.

Curious though, what role would DataStage play here? Other than the launcher, that is?

That's what I was afraid of... that's definitely a 7.5.x feature.

What exact version of DataStage are you running? If you have a later version that supports Job Parameters in the Notification Activity, you can tell from inside the stage. Is there a 'browse' (...) button for that field? When you click it, does it open the External Parameter Helper dialogue? If so, ...

mctny wrote:so does this DSX cutter work for version 7.1, i.e., jobs designed with DS version 7.1 server edition and exported into a dsx file?

Sure.

Ray - you need to have multiple links from the same Transformer to a single OCI stage before the option becomes available on the Transaction tab of that OCI stage. And you need to then enable it before the options being questioned shows up.

You've posted this question twice. Please delete the duplicate post before someone replies to it.