DSXchange

I'm assuming it is way too late for any suggestions if your plans are already set. I've been through an Oracle-to-Teradata forklift project, heard the comments from both sides and seen the ultimate result - failure. They dumped Teradata and went back to Oracle. It probably should never have been att...

Ah... you so right. That was the one that I was trying to remember but my searching only turned up the other two.

Mistake.

I hope you guys didn't just "forklift" the Oracle structures over to Teradata.

You might start by searching the forums here for UVFIXFILE or fixtool.

In a Server job, one can define their own collating sequence in a Sort stage so that it knew to sort H then D then T. Is there an equivalent on the PX side?

Unfortunately, the Guide is known to have misinformation in it regarding the Modify stage.

Actually, they're not. What you have in sequential files are empty fields rather than nulls.

Please start a new post and give us the details of your problem.

The only time I've seen anything remotely like this, it turned out to be a database client software bug. What does your official support provider have to say on the topic?

Space is space, no matter if it's all in one file or many... perhaps you meant a file size issue? Regardless, what you want to take advantage of is the Trigger Column in the XML Output stage. Every time the value in the column changes, the output file is closed and a new one is opened. It doesn't ne...

I'll be curious what we find out, I'm just going by what I've read here and have no way to do any actual testing of this.

I'm sure I'm in the same camp as many people here - I don't have access to either databases at the moment. Help us help you: what does the source data from DB2 look like? What does it need to look like to load into Teradata? Actual examples would be good.

My understanding is you'd need to use a BASIC Transformer to do that. Either that or it's not possible.

Barring a code fix, could you replace using a character you "know" won't be in the source string? Say, something like "^" or "|" then convert that out afterwards.