DSXchange

It's going to come down to character sets, so to take this any further you'd need to know what that is in your Oracle database and your PX job before anyone could help.

Yes, it may be possible if your source is static and the 'how' is the same regardless of version - you simply skip the records that you don't want to process. A common methodology would be via a job parameter and a transformer constraint.

Sure sounds like a (poorly worded) interview question to me. To what 'intermediate results' do you refer?

'Workflows'?

Regardless, of course there's a limit but it's not a DataStage one but rather a resource one.

There's no such thing as a free version for anyone to download and play with.

Really shouldn't matter as you should do this in the Initial Value of a stage variable so it is only derived once. Unless you need to change the value when the job starts before but runs past midnight?

Two steps, actually. Date() or @DATE will get it in internal format then OConv() can convert it to any format. Or Field(TimeDate()," ",1,3) but you'll still need to 'adjust' the output.

Sure... but the first question is going to be - what is your definition of a month? Were you given any business rules on how to compute this? Is this always a whole number? (etc etc etc)

Well, there's always the manuals and the 'Help' button inside each stage. And this Best Practices Document which is chock full o' useful nuggets.

In "the data" means what, exactly? The XML you are trying to read? I find it odd that you'd have extended ASCII characters in an XML file.

Please realize that I specifically said I didn't recommend it for parameters with values that need to change from run to run. They are suited for parameters that change value from environment to environment (hence the name) - typically ones that change from dev to test to prod like database credenti...

A guess but the other thing you might try for the folder pathname is "D:", just the drive letter without the slash.

Does your user have access to that drive? Does it work if you actually put the file in a directory rather than in the root of the drive like that? I've got no way to test this, you'll need to experiment a little to see what works.

Those are runtime not compiler errors. You need to set the Folder Pathname to a directory and then the filename in the Wildcard property even if you don't need a wildcard. Looks like you've put both in the Folder Pathname.

Nothing built in for that AFAIK. Perhaps an upstream Remove Duplicates stage?