DSXchange

Start first by fully explaining your requirements. For example, this "difference" column - how is it calculated? What exactly is it the difference of? Don't expect people to just magically know or expect them to puzzle it out for you. And please stop using "+ve", there's no such ...

No, we're in the Server forum but you've marked the Job Type as 'Parallel'... just want to make sure you're getting the right answer. So are we still talking about a Server job or not?

... all of which is completely controlled by the stats / histograms of the target unless you use hints to override the CBO. What advice does your DBA have?

What happens if you don't "format" the XML?

First let's get you in the right forum... there, done.

Second, we need to ask about what you searched for here. Both "Failed to register this user for SQL" and "is not a valid SQL user" should help.

So, actually a question about a Server job?

If I avoid the routine call and instead provide the derivation above for the column, will I get any significant improve in the job performance? None whatsoever. You'd be better off letting Oracle handle the timestamp if it truly needed to be "real time". Better to capture the "job st...

What did your Teradata DBA have to say regarding the error? Have you tried posting it in any Teradata dedicated forums?

I don't see how treating "consecutive delimiters as one" would help here but perhaps I'm missing something, late on a Sunday night. Seems to me that would just slide any following fields down into the wrong column. :? Still, bottom line is your file is invalid as a delimited file. I know y...

If you want to do insert only, use a lookup to determine if the data already exists and then only insert those that do not. That or take the "insert else update" approach but you'll need a unique contraint to allow that to work.

It's a Teradata error, suggest you google for "the string contains an untranslatable character" which seems to be the actual message and see if any of their advice helps.

Then get whomever is producing the file for you to create it properly. Either quote the fields or use a delimiter that does not occur in the data. Or both.

Are your stats on the target table up-to-date? Have you tried using a hint?

What are you trying to accomplish? A before/after is not meant to be called in a Routine Activity stage, but rather before or after a job or stage. And as noted, anything other than '0' in them causes an abort.

For any kind of "assert" error, I would involve your official support provider.