DSXchange

Okay, I'll answer right away. The best practice is always put a Transformer between two Passive stages. The default Transformer that is stuck there is not the same as a real Transformer and you may experience problems because of the differences. Don't ask me the differences - I can tell you they ar...

Search the forums for "does not fulfill the sort requirements of the downstream operator".

<redacted>

Keep your 9i client for use with 10g when you upgrade. And, from what I recall, 7.5 was the first version that 'officially' supported 10g.

Always best to create your own post and then link to any similar post, especially if the one you found is old. That or at least click on the original poster's name then 'Find all posts' to see when the last time was they've posted. Amos hasn't posted in almost a year and a half, for example. Better ...

I'm curious where you got %ms from, a guess? The docs show %ss.n where n is the fractional seconds with a maximum value of 6.

prasadcp wrote:BTW, Is there any alternate way to implement delete-n-insert - apart from an upsert??

Sure, two separate operations - first perform all of the deletes and then all of the inserts.

No. As Ray notes, they are not stored in any kind of 'external' or formatted way, but in binary. It is the Viewer that is trying to be helpful and adds all of those zeroes when you view the data as noted to 'remind you' of the precision and scale.

No, not dedicated - random. These are business names so the *vast* majority of records won't have this symbol in them, but when they do it could be anywhere. And any could have & and ' and all that other phun stuff that XML wants encoded. I'll ponder the idea of separating this out into it's own...

Of course you do. Something has to parse that into the appropriate columns.

Shared Containers don't need both an input and an output link, one or the other is fine. No, they don't. But, if I convert an output file (say, myFile.txt) to a shared container, I will NOT be able to use that shared container as an input stage (containing myFile.txt) in another job. If I were able...

Thanks for fixing that John.

Again, once I went go this path of manual intervention...

chulett wrote:The other problem would be, once I build the element myself, I would need to start manually handling all encoding that needs to happen (like &apos; and &quot;)... yes?

Right? Yuck.

Hard to say. What happens when you execute that code snippet from the command line, does it work? And we'll never know what's going wrong in your script if you don't add better debugging information. It's been mentioned as least three times that you need to capture 'standard error' in your script so...

Here's a thought... why don't we wait and see? No sense continuing to thrash.