Floating data type

sourabhk1148999

28-08-2019

Hi Team,

Is there any way to take any floating type data up to 4 decimal digital place and load to schema with help of data Loading Activity.Whenever I am taking the floating datatype in declaring column details in data loading activity it will trucnate the alst 2 decimal digits also tried same with  double precision.

Sample data is 13456567.2363.

Regards,

Sourabh

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

05-09-2019

Hi,

The console UI will only display 2 digits precision, though the data will be same as ingested.

E.g. @col > 1 will return values 1.0001.

UI will also display null number values as 0, among other quirks.

Thanks,

-Jon