Welcome Guest! Log in


The forum is in read only mode.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…

Topic-icon Question LOAD Rdbms To Teradata (with multiload)

04 Sep 2015 16:11 #1 by Kalina

In the case when UNICODE column is used in RDBMS, load table during step called 'Creation of load table' is created with LATIN fields anyway, so mload errors occur.

We've found that current expression to generate load table DDL is:
create  MULTISET  table %x{md:physicalPath($REF,'workName')}x%
	%x{md:patternList($REF/ref:columns(),'[workName]\t[targetWritableType] [targetNullWord]',',\n\t')}x%	
	%x{if ($REF/tech:hasCdc()) then ', CDC_CHANGE_TYPE CHAR(1)' else ''}x%
PRIMARY INDEX ( %x{md:list($targetPI/col/@workName,', ')}x% )

Is there a way to generate 'CHARACTER SET...' additionally if field type is CHAR or VARCHAR? How can we edit this expression to achieve it? Unfortunately, we haven't found any documentation on that issue and column attributes.

Thank you in advance.
04 Sep 2015 18:07 #2 by Thomas BLETON
Replied by Thomas BLETON on topic LOAD Rdbms To Teradata (with multiload)
Hi, I can't find this expression in my Teradata templates.
Was it modified on your side ?
Note : Templates are components that you can duplicate and edit at will.