DSXchange

Just a note to say that I've seen "client issues" with Oracle where everything works great for years and then one specific thing doesn't work properly - something similar to what you might be seeing. Oddly enough, there can be bugs in Oracle releases :wink: and you may find that there are ...

However, as a general statement while transformers were a 'performance issue' in the beginning, that hasn't been true for quite some time. So simply using transformers in a job should no longer be a concern but best to use them when actually needed - if the work can be done by something native to th...

I mentioned the client issue because I have seen it cause problems so I thought it was worth checking. You've said they haven't changed for years but that doesn't really answer the question as to the version number of each, up to you if you want to double-check on that. And can't really help with th...

How are you performing the SFTP right now? Basically it's just an O/S command to move the files but you would have to have permissions to be able to do that... which is not necessarily a given.

Clarify for us exactly what you mean by "job id". I'm assuming you mean job number so... You need to realize that it is still just a single job being run multiple times simultaneously and all log entries still just go into the 'normal' log table. Think of you checking in the Director for a...

Your understanding seems just fine. Kind of surprised it's still an issue six years on, perhaps you should report it to your official support provider?

What Oracle client version are you using? While your target DB might be 10gR2 there can be two other clients involved - the one on your ETL server (assuming the target instance is located elsewhere) and the one on your PC that you used with SQL Developer. What versions are they? They could all be di...

Doesn't look all that bad and no need for a 'custom stage' for the multiple record types with grouping and detail records. The spec is freely available out there now, here is one such manual documenting it. I also see there are converters for sale (either direction) which might be a more cost effect...

Yes. If this needs to be a PX job then use the Server Sequential File stage in a Server Shared Container.

But Sorry, It's not XML. It is html tags. Your example says otherwise. However, do you actually want to parse information out of the field or are you simply looking for how to read it properly? For the latter, use the Server Sequential File stage as it can handle fields that "contain terminato...

Can you not parse it using an XML stage?

I don't believe so... still, clear it and see if the behavior you are seeing changes at all.

I'd still look at the &PH& directory in the project and see if it has "a large number" of entries in it. And when you are at a point where no jobs are (legitimately) running in it, do the CLEAR.FILE mentioned. Keeping it pruned down - assuming there are many files there - is actual...

These kind of questions seem to go here, so moved your post. FYI.

How is this any different than your original post on this problem? Hint: it's not. If you still have questions or need help, please continue the conversation there.