File Data Store with ASCII Signed Zone Datatype Value is not Visible in ODI Studio after Reverse Engineering
Last updated on MAY 03, 2018
Applies to:Oracle Data Integrator - Version 18.104.22.168.6 and later
Information in this document applies to any platform.
When reverse engineering a File data store with ASCII data, the value of the ASCII signed zone datatype is not visible in Oracle Data Integrator (ODI) Studio 12.2.
A model, associated datastore, and datastore attribute have been defined in ODI Studio > Designer tab. All defined components are based on a flat file input to ODI.
The issue can be reproduced at will with the following steps:
1. In ODI Studio, create a model, associated, datastore, and datastore attribute as described above.
2. Set the attribute type to "Ascii signed zone decimal"
3. Reverse engineer the flat file called <Your_File_Name>.
4. Observe that the value of the attribute described in point 2 above cannot be seen in ODI Studio.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms