A data warehouse is a collection of objects such as databases, tables, users, and many others. Tables hold data which is used to drive business insights and analytics. To get answers to many business requirements, it becomes necessity to join multiple tables.
Not only is this type of join important, but it is also important which columns need to be joined. In this recipe, we will explore which types of columns are good candidates for joins. But sometimes, joining columns can't be changed because of business requirements.
The following are some data types that can be used in Teradata:
| Data Type | Length (Bytes) | Description |
| ByteINT | 1 | Ranges from -127 to +127 |
| CHAR | Fixed format | Â These data types represent character data: Type Varchar, CLOB |
| DATE | 4 | Format YYYYYMMDD |
| TIME | 6/8 | Format Time or Timestamp value HHMMSS.nnnnnn... |
