Schema objects
Schema objects represent different components of the logical data model and are directly mapped to a column or columns in the database. Attributes, facts, functions, and operations, hierarchies, partition mappings, tables, and transformations are all schema objects; however, three schema objects comprise the core of project definition and will be covered in this section:
Attributes
Attributes are the descriptive part of the database. They provide information about the data; for example, customer name and city are attributes. The SELECT clause of a SQL statement is based on these attributes.
The following is the report with the Policy Number and Broker Name as an attribute:
When we see the SQL for this report, the Policy Number and Broker Name will be shown in the SELECT clause as follows:
Attribute types
We have three different types of attribute:
- Compound attribute
- Homogenous attribute
- Heterogeneous attribute
Compound attribute: Uses two or more columns as its ID. It is like...
