FAW - Issue With Loading NUMBER Data Type From OCI Bucket xlsx File
(Doc ID 2923924.1)
Last updated on MAY 01, 2023
Applies to:
Fusion Analytics Warehouse - Version 22.R4.x and laterInformation in this document applies to any platform.
Symptoms
Refer FAW document Section Load Data from Oracle Object Storage into Fusion Analytics Warehouse (Preview),
Object Storage Connection created successfully and you are able to test connection and refresh metadata successfully also.
And then you create New Dimension through data augmentation using files from Object Storage.
Job ran successfully, Table created in backend ADW data warehouse.
Everything looks good for csv data source,
but numeric column value not correct for xlsx data source, i.e 738884.04 loaded as 738884.0400000002.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |