I am new to Teradata, but come from an Oracle background. I am building a Warehouse and want to ensure that I do use storage space effectively. One of the considerations which I am having is define the datatypes effectively.
As such, I would like to understand that if I want to store a single value integer which can have values 1, 2 and 3 then what datatype should I define for it. I think I can define BYTEINT for it. What are your views on this.
Any help in this is much appreciated.
Thanks and Regards,