I am trying to reverse engieer a table from Teradata(Live DB) and convert it into a PDM.
I am having trouble converting unicode columns. For example, if in a table one column is defined as VARCHAR(200) UNICODE; when I reverse engineer this column in my PDM becomes VARCHAR(400). It doubles up all the unicode columns in length. If the column is defined as LATIN, no problem at all.
If I try to reverse engieer through a script, it gives me a correct column length for UNICODE and LATIN.
So, I was wondering is there any option in PowerDesigner to make it right while reverse engieering from a live DB? or am I simply doing something wrong?
Thanks.