Latest Answer : Data Warehousing: It is a process that includes the extracting the data (from source systems), cleaning, transforming and delivering them to the Data Warehouse (databases) for the loading purpose. DWH is a database which is subject oriented, non ...
Latest Answer : 1. ODS - It is a decision support system which contains snapshot of current data for day to day analysis. This may include little history data also OLTP - It is a trasaction system though it contains current data it keeps changing due ...
Latest Answer : dear, according to my knowledge...Business intelligence: business intelligence is a group application which is used to gather information, providing access to, analyze the information and proving this information to end user to take timely ...
Latest Answer : Datawarehouse V/S OLAPBoth the terms are interchangble.DW:Data from different source systems is stored in a relational database for end use analysis.Data is organized in summarized, aggregated,subject-oriented,non-vilatile pattern.Data in a DW is consolidated,flexible ...
Latest Answer : hi nice ans u given and i think we can add number of of levels under hirarchy ...
What is the difference between E-R modelling and Dimendional modelling? and what are semi additive facts?
Latest Answer : An MDDB is generally used where large number of aggregations and summarizations are required along with a very fast retrieval of data.Here the data is stored in the form of multidiemnsional cube(however physically it is also implemented in the form of ...