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
Userlevel 2
+12
- Contributor
- 2177 replies
-
20 April 2018
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.
Userlevel 2
+17
- Contributor
- 7538 replies
-
21 April 2018
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.