DSXchange

As long as it's a supported version of Linux, I don't see why not. But then I've never had the pleasure of trying any such thing, so don't take my word for it.

I think mostly because only Ray actually uses it. Honestly, I have no idea. For the longest time I didn't even know it existed, only learning of it here. Since then, I've just stuck with the 'traditional' client-based solution I've always done, exports of all projects. Mostly since I would know what...

Funny, pretty much exactly what I posted.

First determine the bottleneck. If you replace the Hashed File stage with a Sequential File stage, who long does it take to run then?

You need to not be removing lines and instead determine the exact nature of the problem and if it is possible to read the file properly. Some badly formated delimited files can be... problematic and should be returned to sender. Otherwise, these turn out to be 'normal' issues you need to learn how t...

And 'maybe' I was being a wizenheimer about the Arabian comment, and not supporting anything about 'Arabic' script. I'm not the World Traveller that Uncle Ray is, nor nearly as cool.

Maybe he meant what the horses speak.

Is there a way to write the output to a single file when the "Output Mode" is set to "Single Row"? No. You need to 'Aggregate all rows' to get one output file. Or perhaps direct the output through a Sequential File stage, but I haven't really done that much and let the XML Output stage do the dirty...

Come on, it's not irrelevant as in "unrelated to the matter being considered". It may be less relevant than my 'only works on' statement would lead one to believe, that wasn't quite true. Sure it 'works' on a single CPU system but it is really meant for use on SMP systems. Yes? And all we're referen...

That's what Enterprise Schedulers are for, tools like Control-M would make that simple. It's more complicated to juggle all of that within DataStage. Sun Rays has given you some food for thought on how to create the inter-dependencies you'd need.

We have yet to determine it is being incorrectly interpreted.

Not sure that's a real "apples to apples" comparison. But then I'm no NLS or PX expert, others would need to chime in based on the results of your investigation.

They are synonymous in this context. Not necessarily the one 'you are working in' however, unless it is left blank. Hence my curiosity about what exactly was created via the Administrator.

The problem with just answering brief questions of this nature from people with low post counts is the very distinct possibility they are just here to farm answers for interview questions. Which is a practice highly frowned upon here. <- See, that's me frowning. This looks too much like one of those...

How did you 'create a new account' in the Manager?

Multi-byte character set, I'd wager. What two NLS_CHARACTERSET settings are involved here?