If I have a source data mortgage amount stored in an integer, but if this value is summed nationwide is too big to fit in an integer and will cause an overflow, do I leave this column as integer in fact table instead of bigint to save space and analysis
services can take care of overflow or ?
If I leave the column as integer in fact table do I need to be customizing these type columns that can cause overflow in analysis services ?
A 32-bit signed integer that represents signed integers with values that range from negative 2,147,483,648 through positive 2,147,483,647. You can perform a test to see if the measre data beyond the scope or not.