DSXchange

Other than data loss and corruption, no.

:? How is that other post not helping? In short you need to understand why you are violating that check constraint (look it up in the database or talk to your DBA if you are unsure) and then ensure in your job that you pass only "good" values to that column. That could mean setting "b...

Either do a UNION there or use multiple source stages and a Funnel.

Please explain what "does not pass" means. I'll wager you have nulls in there you're not handling properly and all you get out the other side is an empty string. And please do a better job of picking subjects, they should be indicative of the actual problem. We already know you are having ...

Ugh, that's going to be an unwieldy solution, not to mention harder to code and maintain then you can possible imagine. You'd have to go "BCI" and leverage ODBC and then deal with the fact that the supplied ODBC drivers are not licensed for use outside of the GUI. Far better to stick with ...

This looks like something that should be posted in the QualityStage forum.

Hashed files? Pathed ones can be simply copied over to any path on the new server, but account based ones won't be in the export and will require more manual effort to migrate.

For the uninitiated, can you explain what a "transparent" lookup would be? I'm also curious what you meant by "Writing to hash files required a full fledged coding and a tiresome job".

I don't see what (1) has to do with loading Oracle. And a bulk load will always be the fastest way to get pure inserts into a database, without really needing to mess with the control file.

There's no way the find command is taking 27 minutes. Seek your bottleneck elsewhere.

You guess?

viewtopic.php?t=107844

Reconfigured? No, I don't believe so. Have you gone thru the documentation yet? Just to be safe, have you confirmed that 8.1 is supported on AIX 6.1?

No idea, and an "unspecified error" doesn't give anyone much to go on. Are there any other messages logged? Can your DBA help by tracing your activity and seeing if there are any issues they can see from their end? If the job is aborting, Reset it and let us know the contents of any 'From ...

This is not typically any kind of choice that "you" (or any of us for that matter) make but rather have thrust upon us. Between infrastructure / admins / The Powers That Be they'll let you know which one you'll be using.

There's no parameter for that. Suggest you involve your official support vendor as that smells somewhat buggy to me. Could be in the Oracle client, could be in the stage, best to ask them.