DSXchange

Oh dear. They are the 'expressions' you put in the Description field to tell the parser how to parse each field from the XML. Do you have an "xsd" for this file, something that describes all of the fields in the file? You can use that with the Metadata Importer and it will generate the XPa...

For starters, a TinyInt is only a single byte so the values you've posted for it are definitely 'out of range'.

Do not read XML with the Sequential File stage, that's what the Folder stage is for. Also, how did you generate the XPath Expressions you are using, from an xsd?

Not going to be all that helpful, but it's called the 'Grid View' and you can see it in other stages as a right-click option. No clue how it gets to be permanent or how you switch it back, however.

Let's move it to General for now.

Anand, please edit your post and include all of the missing information it prompts for: version, O/S, etc.

Yes, as noted.

Did say I couldn't check, as in I don't have any kind of DataStage access at all, but I do have a smattering of documentation plus what's left of my memory. For now.

Have you done an exact search for 'vertical pivot'? It has been explained here a number of times.

IPC is no magic bullet and you'll still end up with a transformer in the job. Best to learn what those OCI settings mean and control them properly. http://it.toolbox.com/blogs/infosphere/ten-reasons-why-you-need-datastage-85-42312 Reason #10 is the 'Balanced Optimizer', the equivalent of your 'pushd...

Your target array size is killing you. Did you try the @FALSE suggestion? I'd still be curious what your 'Update Action' is but in the meantime bump up your target array size to something larger so you are not sending one record at a time across the network to the database. Perhaps 1000 to start wit...

Or understand why it is happening and deal with or adapt it as Ray notes, rather than force your parallel job to run sequential.

This also involves payment to IBM as a prerequisite.

Yes.

How many nodes is your job running on? More than one, it seems.

palak08 wrote:Do you think I should not get this error if I am providing directory path even if it is project directory??

Yes, that is exactly what I think and said.

You might want to flag each record with the validation error(s) that caused the reject, unless you don't mind figuring it out all over again later.