How to Change Scale and Precision at Table Level for Table Columns

Issue

During Oracle ingestion, the crawled data might not be accurate due to Scale and Precision values of the Oracle table columns. This is limited to Oracle decimal columns. The value for respective source columns vary in the target Hive data lake tables.

Cause

Data mapping settings that are not set during the Oracle ingestion leads to this issue.

Solution

• To modify the Precision and Scale for a column in the table in the Infoworks source, ensure the source and target data are the same and there are no corrupt/modified values in the target Hive tables.
• Add a key and value in the table level settings for the table which includes the columns to be modified.

Following are the steps to add the key and modify the Scale and Precision:

NOTE: The following settings can be applied only at table level and not at source level.

• In the Infoworks ADE, navigate to the Source > Source Configurations.
• Click the required table.
• Click Advanced Configurations > Add Configurations.
• To set the precision, enter the following: Key - TABLENAME.COLUMNNAME.PRECISION, Value - 38

NOTE: You can set the value as required.

• Ensure that the is Active checkbox is selected and click the Save button.
• To set the scale, enter the following: Key - TABLENAME.COLUMNNAME.SCALE, Value - 18

NOTE: You can set the value as required.

• Ensure that the isActive checkbox is selected and click the Save button.
• Repeat the same steps for the other required columns and save the configurations.

Applicable Versions

• All versions