Caboodle Concepts Questions and Answers with complete solution

Caboodle Console - Caboodle comes with a set of administrative tools. These tools can be accessed using this. This is a web application housed on the Caboodle server. Data Warehouse - stores data from multiple sources, both epic and non-epic. provide a common data model for all data. makes it easier to report on and analyze data from many sources. ETL (Extract Transform Load) - Extract, Transform, Load process. This process is the flow of data from chronicles, to clarity, and to caboodle. SSIS Package (SQL Server Integration Service) - The movement of data from one database to another is realized using a set of these. Data Lineage - the process of identifying the source of a specific piece of information. In Caboodle, this is defined at the package level. Star Schema - a fact table typically contains lookup columns to several dimension tables. The arrangement somewhat resembles this. DMC (Data Model Component) - the collection of metadata tables that support the ETL process and reporting views stores in the FullAccess schema. Includes facts, dimensions, bridges and their associated packages and metadata. Staging Database - Data is extracted from source system, and transformed in this database. Reporting Database - Data is presented to users in this database. DBO Schema - Stores reporting data and acts as the data source for SlicerDicer. Caboodle dictionary reflects the contents of this.FullAccess Schema - Houses views that simplify reporting. Should be the default schema when reporting. Does not exist in the staging database.