Most staging (STG_*) tables are intended for internal purposes only, with the exception of two tables that are useful for troubleshooting errors in the source data that cause ETL jobs to either generate exceptions or fail. They provide temporary storage for those interaction records that may be subject to the merge process.
Merge tables within the Info Mart database are intended for internal purposes only. Genesys Info Mart further processes (transforms) GIDB data to create data representations useful for end-user reports. This part of the Info Mart database is designed to keep all records that are extracted from various IDBs and subsequently merged, so that coherent reporting data at the lowest level of detail is gathered from the entire contact center and stored within a single data warehouse for as long as customers require detailed data. GIDB stands for Global Interaction Database.
For more information, see Info Mart Service and Control Tables. Whereas most control (service) tables are intended for internal purposes, certain CTL_* tables contain operational data that is helpful to system integrators and system administrators in their data validation and troubleshooting tasks. For a discussion of dimension views, see Dimension Views. name) Single-Valued versus Multi-valued Attribute (e.g Qualifications) Stored versus Derived Attributes (e.g Age & DoB) Identifier Attributes Identifier - An attribute (or combination of attributes) that uniquely identifies individual instances of an entity type Simple Key versus Composite KeyĦ ERD Example Title FIrstName LastName MovieID Duration CustomerID Address Rating CUSTOMER BirthDate PhoneNumber PRODUCER CompanyID CompanyName CountryĨ Relationships Relationship Types vs.ImportantGenesys Info Mart database schema includes a set of dimension views, in addition to dimension tables. 1 An Example: Video Rental System Video Rental Database Customers Rentals Videosĥ Attributes Attribute - property or characteristic of an entity type Classifications of attributes: Required versus Optional Attributes Simple versus Composite Attribute (e.g.
0 kommentar(er)
