DSXchange

Yes, it exists. It's a Sequence job stage.

Yes, via a stage variable in a transformer.

1. It looks like that option was added in the 8.x release, so no. 2. You can generate the current row number if you are careful with any partitioning. If you need to know the total number of records while the job runs, you'll need to count them ahead of time and pass the count in as a job parameter.

Make sure your output is a string and use an appropriate mask for the DateToString() function, i.e. one without delimiters.

There is, however, a Convert() function which converts one character with another. Same thing, really.

Easily? Not sure there's an easily here but I would imagine you could whip up something in C++ to do this.

Because of the 'T' and thus your use of "%DDT" in the mask. Convert it to a space and then convert the timestamp like 'normal'.

That's an OCI error and the fact that it goes away on a re-run will make it difficult to track down. You'd really need to involve your official support provider to get to the bottom of this but let's start with some questions: what version of the Oracle client is installed on the DataStage server? I...

"Reduced by 2 minutes" is pretty meaningless on its own, what was the total run-time before and after? If all you've performed is one test on a small number of rows, that could simply be a normal variance. As to the IPC stage, they're not the silver bullet people seem to think they are. An...

1. Try it, let us know

2. I assume "1" since anything higher would imply the use of an array

3. No

Before we go too far down the rabbit hole, define for us what you mean by "arrays"... and why you are asking this question. What do you have in mind?

Sounds much the same as this issue. Short answer to the question in the subject? You can't.

The where clause is automatically generated for any columns marked as a "key".

I'm not sure why you would check a stage variable and then convert something else, might work better if you convert vCleanRec as well. Biggest thing is the "inputx" after the if that is not needed and probably messing up the output. First try this to minimize the changes: If IsValid("...