Hello! I am trying to dynamically load tables from an Oracle database (both spatial and non-spatial) to an Informix database. To do this I need to change the case of all the attributes from uppercase to lowercase. When I do this using the BulkAttributeRenamer, all the feature types all become lvarchar. Is there a way to keep the type?
It would be more accurate to say I am losing the metadata somewhere between the renamer and the informix writer. When I dont do the bulk attribute renamer, the informix writer can infer the feature types. If rename, it makes them all lvarchar
+17- Contributor
So the lvarchar is set as the default for attributes that can not be defined by source attributes.
If you do not rename, the source attribute will provide the datatype.
Not sure if a way exist to define the default datatype.
+21- Contributor
How have you configured the destination schema in the writer feature type?
If you post a screenshot of the writer feature type properties dialog, it would help us to find what could cause the issue.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.