Counter KF with 1 & 0 and difference between data type NUMBER (DEC) and INTEGER (INT4)

[former_member210874]

Hi,

I need to create a counter kf which should populate 1 and 0 to this counter field. Please let me know is there any difference between data type

NUMBER (DEC) and INTEGER (INT4).

Please suggest.

Thanks & Regards,

Pavan kumar

[Former Member]

Hi Pavan,

The basic difference between Number(DEC) and INT4 is its internal storage in system.

For Number (DEC) - Value internally stored as packed number with 3 decimal places whereas INT 4 as 4 byte integer without decimal places.

For counter KF, you can go for INT 4.

Hope this helps.

Thanks