‘Uncategorized’ Archives
Defination of Correlated Subquery
In job interview for a database / sql programmer a question is sometime asked what is a correlated Sub query? A sub query containing an outer reference is called correlated sub query, because its results are correlated with each individual row of the main query. For the same reason, an outer reference is sometimes called a correlated reference. [...]
Data Staging (ETL) in Business language
We are researching Specifically with business users in mind and accordingly presenting some information On Data Staging which is ; Getting data out of source systems and into the data warehouse in reasonable and rational format is by far the largest effort of building data warehouse. This activity can account for 80% of the total efforts of the [...]
Data mart & crystal reports
Data marts can bring diverse data sources into one place for timely, detailed information to make smart business decisions and easy report creation with Business Objects, Cognos, Crystal Reports, SAS and other tools.
Accounting centric data warehouse / accounting data mart
Building an Accounting centric data warehouse (ACDW) is an incremental process. Overtime collection of data marts, each supporting a different analytical need or business process, are developed to composed the ACDW. What makes ACDW different from a data warehouse is the General Ledger integration. With GL data, a complete top to bottom view of the [...]
Functional datamarts
A data mart is a subset of an Enterprise Data ware house, perform the role of departmental, regional, or functional data ware house. An organization builds a series of data marts over time and eventually linked them via an enterprise wide, logical data warehouses. A data mart is generally focuses on single subject area and is generally determined [...]
