What is the difference between E-R modelling and Dimendional modelling? and what are semi additive facts?
Latest Answer: hi nice ans u given and i think we can add number of of levels under hirarchy ...
Latest Answer: Hi ,I-Bot is a object which we configure in Siebel web catalog for generating auto report to perticular person.See i will give example my manager want the report of perticular sales area that how sells has been done so i will go to tab which is nearby ...
Latest Answer: Multidimensional databases consolidate and calculate data to provide different views. With Multidimensional databases users can pivot the data to see the information from different view point. It contains Outlines that defines all the elements of the ...
Latest Answer: Aggregate table contains summarised data. The materialized view are aggregated tables. for ex in sales we have only date transaction. if we want to create a report like sales by product per year. in such cases we aggregate the date vales into week_agg, ...
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: 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: 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: There are two kinds of fact tables which don't have any facts at all. They are called FACTLESS FACT TABLES. As per Kimball's law, every M-M relationship is a fact table. They may consists of nothing but keys. First type ...
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 ...
View page << Previous 1 [2] 3 4 Next >>
Go Top
