DSXchange

Any time I've seen anything like this, it is some kind of user or configuration error. I honestly don't see how it could be anything else but there's always a first time. Have you verified the tnsnames entry you are using for the target is correct? It sounds like you have by changing the sql but it'...

If you want more help, you'd have to explain what you tried and what "partly working" means.

You tell me, I have no DS access at the moment. If you don't see it in the ODBC stage then use the DRS stage instead.

Is your connection information parameterized? Are you perhaps accidentally using your source connection parameters for the target OE stage?

Your "SET" lines need to be in the before- and after-sql areas, respectively. You want them run once per session, not once per row.

Your user-define sql may be invalid for operation in the stage - can you post it? And explain what it is meant to do?

Been discussed quite a bit here, do an exact search on "special characters" and you'll see that for yourself.

You seem to be having this conversation with yourself...

Not much detail.

Try an exact search for "The DataDirect ODBC driver you are attempting to access" and see if any of the other posts that mention that error help, you are having some kind of "licensing" issue, it would seem.

And... you get this where? when? doing what?

I think it's safe to imply from the question that yes, they should be so marked.

I did, mostly. It will "work correctly" as the number of records really has no bearing on this except for any performance discussions and I can't address that for billions of records. I've done it with millions but not billions. There's obviously some overhead to having to generate any has...

That's fine and a pretty common use of that function, what I was commenting on was your first sentence: "I want to use the inbuilt checkSum stage in DS8.1 to generate a unique key". It doesn't generate a unique key although we've had people attempt to use it for that purpose, hence the con...

First off, your subject - are you saying this was or is an interview question? Those are... how do you say... frowned on here. Plus I don't understand the relationship between your subject and your post. And I have no idea what the arrow (----->) in your "output like this" example is suppo...

Hard to say, since you haven't told us what that characterset (source or target) is as of yet.