Tagged: EDW

0

Hive datatype mappings

Hive meaning Teradata meaning .net BCL Type TINYINT 1-byte signed integer, from -128 to 127 ByteInt Represents a 8-bit (1-byte) signed integer. Range: -128 to 127 System.Int16 SMALLINT  2-byte signed integer, from -32,768 to 32,767  SmallInt Represents a 16-bit (2-Byte) signed integer. Range: -32,768 to 32,767...

0

Introduction to CDC

Source: http://www.dwh-club.com/dwh-bi-articles/change-data-capture-methods.html Author(s): Bralgin, Igor   Introduction to CDC According as to its definition and to its aims, a Data Warehouse (DWH) must maintain the history of business measures’ changes. Thus the ETL processes of the Data Warehouse loading must...