CDC Between Sequential File & Teradata Enterprise data s
Posted: Fri Jul 13, 2007 12:46 pm
Here is our job design
Teradata Enterprise -------> |
------------------------------------| Change Capture ------> Output
Sequential File----------------> |
Here data from Teradata Enterprise and Sequential file are identical, but CDC gives most of the record as new records.
"main_program: When preparing operator: When setting up transfer for "LN1_ADR":Implicit conversion from source type "ustring[max=60]" to dest type "string[max=60]": Converting ustring to string using codepage ISO-8859-1."
We identified above warning and we tried changing extended property to "UNICODE" and it works fine as it suppose to be.
Following is "tera_cs.txt" 18 lines, 662 characters
ASCL_LATIN LATIN1_0A
ASCL_EBCDIC EBCDIC
ASCL_KSC5601 HANGULKSC5601_2R4
Shift_JIS KANJISJIS_0S
ASCL_SHIFT-JIS KANJISJIS_0S
ASCL_JPN-EUC KANJIEUC_0U
ASCL_MS1252 LATIN1252_0A
ibm277 EBCDIC277_0E
ASCL_EBCDIC-IBM933 HANGULEBCDIC933_1II
ASCL_EBCDIC-IBM937 TCHEBCDIC937_3IB
ASCL_EBCDIC-037 EBCDIC037_0E
IBM273 EBCDIC273_0E
ASCL_EBCDIC-1026 KANJIEBCDIC5026_0I
ASCL_ISO8859-9 LATIN9_0A
ASCL_GB2312 SCHGB2312_1T0
ASCL_BIG5 TCHBIG5_1R0
ibm-1047-s390 EBCDIC
ISO-8859-1 ASCII
We have tried APT_TERA_NO_SQL_CONVERSION environment variable option also.
Does anyone have faced this problem?
Is there any better way of solving this problem instead of changing the metadata to UNICODE?
Any response on this will be greatly appriciated.
Teradata Enterprise -------> |
------------------------------------| Change Capture ------> Output
Sequential File----------------> |
Here data from Teradata Enterprise and Sequential file are identical, but CDC gives most of the record as new records.
"main_program: When preparing operator: When setting up transfer for "LN1_ADR":Implicit conversion from source type "ustring[max=60]" to dest type "string[max=60]": Converting ustring to string using codepage ISO-8859-1."
We identified above warning and we tried changing extended property to "UNICODE" and it works fine as it suppose to be.
Following is "tera_cs.txt" 18 lines, 662 characters
ASCL_LATIN LATIN1_0A
ASCL_EBCDIC EBCDIC
ASCL_KSC5601 HANGULKSC5601_2R4
Shift_JIS KANJISJIS_0S
ASCL_SHIFT-JIS KANJISJIS_0S
ASCL_JPN-EUC KANJIEUC_0U
ASCL_MS1252 LATIN1252_0A
ibm277 EBCDIC277_0E
ASCL_EBCDIC-IBM933 HANGULEBCDIC933_1II
ASCL_EBCDIC-IBM937 TCHEBCDIC937_3IB
ASCL_EBCDIC-037 EBCDIC037_0E
IBM273 EBCDIC273_0E
ASCL_EBCDIC-1026 KANJIEBCDIC5026_0I
ASCL_ISO8859-9 LATIN9_0A
ASCL_GB2312 SCHGB2312_1T0
ASCL_BIG5 TCHBIG5_1R0
ibm-1047-s390 EBCDIC
ISO-8859-1 ASCII
We have tried APT_TERA_NO_SQL_CONVERSION environment variable option also.
Does anyone have faced this problem?
Is there any better way of solving this problem instead of changing the metadata to UNICODE?
Any response on this will be greatly appriciated.