DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
kurics40



Group memberships:
Premium Members

Joined: 18 Nov 2009
Posts: 61

Points: 968

Post Posted: Mon Nov 19, 2018 1:23 am Reply with quote    Back to top    

As some of my colleague asked more workarounds:

You can create error table in teradata of any table:

Syntax
CREATE ERROR TABLE FOR tbl_name;

What I recognized that many quick and dirty developers try to load the data in ansi mode because it gives no error. If the data is in UTF8 it is highly not recommended to load in ANSI. UTF8 can represent a character in 1 or 2 or 3 or 4 bytes as a multibyte character. If ANSI latin mode mapps each byte as a valid character than it screws up the data in irreversible way in the target, unless the UTF8 data content matches in a special scenario with ANSI latin characterset.
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 43035
Location: Denver, CO
Points: 222143

Post Posted: Mon Nov 19, 2018 5:48 am Reply with quote    Back to top    

Wowzer... almost 9 years later. Wink

_________________
-craig

I've all my wisdom teeth, Two up top, two beneath
And yet I'll recognize my mouth says things that aren't so wise
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours