Target Audience: All infoworks Users


How to  change the Scale and Precision at table level for table columns


Users may need to modify the Precision and Scale for certain column present the table in the Infoworks source. This might be required to ensure the source and target data are exactly the same and there are no corrupt/modified values present in target hive tables.


To make this possible we need to add a key, value in the Table level settings for the table which has these columns which need this changes.


Please follow the below steps to add the key and modify the Scale and Precision as needed.


1. In Infoworks UI navigate to the Source --> Source Configurations --> click on the table name-->Advanced Configurations-->Click Add Configurations

now you will be provided with a new window which has Key and textbox followed by Value and textBox followed by Description and Textbox


Please add the below values in Key TextBox

TABLENAME.COLUMNNAME.PRECISION

Please add the below values in Value TextBox

38

Please note( You must add the desired values according to your requirement)


Make sure you have selected the checkbox (isActive) and click the Save button


To the Scale value please click on Add Configuration button


Please add the below values in Key TextBox

TABLENAME.COLUMNNAME.SCALE

Please add the below values in Value TextBox

18

Please note( You must add the desired values according to your requirement)

Make sure you have selected the checkbox (isActive) and click the Save button


Repeat the same steps for other columns which need such change and save the configurations.


PS: This works fine with Infoworks version 2.3.X and 2.4.X

This modification can be only done at table level and not at  Source level



Thanks,

Sri