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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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
+22- Contributor
- 2179 replies
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.
- 7843 replies
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.