DSXchange

It would have helped head off that first "wtf?" reaction from me, yes.

While you may be able to do something like that in the source sql, at least for the primary group, me I would stick with handling all that "in job".

Hashed files are overrated anyway, right? Overrated? Are you kidding? They are the heart and soul of server jobs, something you will (and should be) leveraging to the hilt in whatever Server based solutions you build. Learn them. Love them. :wink: My issue was an aberration. Yours... disk, I assume...

I've seen something like this. At my last client's site, one particular job that populated a rather large hashed file would bring the server to its knees when it ran, right down to that same painful 15 second pwd. This wasn't a generic issue but was (thankfully) isolated to this one particular job. ...

I'm sorry, I can't help at all with this issue but there was a bit of an eye-popping comment in there, so I just had to post...



69 thousand schemas? Holy.... never seen anything even remotely close to that in my life.

Ah... you'll also get something like this when a job parameter is used there and it is not properly specified so doesn't get resolved. Oracle doesn't like the left over hash/pound signs then.

Please mark your post as Resolved using the button at the top of the page.

What exact flavor/version of Oracle is this? What client version are you using to connect to it?

Stop using 'View Data' as a validation of exactly what the data looks like in the target.

Probably, but without details that's about the best answer you'll get. So... one particular job? All jobs? Jobs that otherwise run fine from the GUI? Details, man.

And to clarify, how many rows are we discussing here? You are extracting many and you get one error in the bunch? All of the rows throw this error? You are only working with this one troublesome record at the moment? Something else?

Exactly how I have done this in the past. And what I would have posted.

Which stage are you planning on using? OCI or ODBC? They have different configuration requirements. And there's no dsenv file on a DataStage Windows server, so don't go looking for that either.

Same answer as you got in your other post. And if you want multiple files you have to let the XML Output stage do the writing, not a downstream Sequential File stage.

Which part is unclear? Have you done an exact search for "Ignoring duplicate entry"?

I believe you'll find that StringToDecimal() is valid in a Transformer while the Modify stage uses something like decimal_from_string() but not positive.