Dataset Tables
The data warehouse contains separate, but related tables for the various CloudBilling entities such as Customer, Products, Invoices, Line Items, etc. Each table contains a list of attributes, represented as table columns, to describe the various properties of the entity. Each attribute has a name and a type. For example, some Customer’s attributes are Customer Code, Name, Country, and Address Line 1, and some Product’s attributes are Name and Cluster. All entity tables contain an attribute called Primary Key (PK) that uniquely defines a record in that table. The PK attribute is used to link various tables to each other and retrieve data spanning across multiple tables.
The following sections will provide detailed description of the attributes for each table and important considerations.