Latest Answer: There are basically three types of Facts :1) Additive Facts2) Non- Additive Facts3) Semi-Additive factsAdditive facts are those facts which we can aggregate or we can add.For e.g 2+7=9.Non-additive facts are those facts which we can't aggregate or ...
Latest Answer: According to Kimball"Factless fact table are the preferred method of recording the events in the DW where there is no natural numeric measurement associated with the event. Factless fact tables also are used to gurantee coverage" ...
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: Type1: Rows containing changes to existing dimensions are updated in the target by overwriting the existing dimension. In the Type 1 Dimension mapping, all rows contain current dimension data. Use the Type 1 Dimension mapping to update a slowly changing ...
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: Active Data Warehousing (ADW)The technical ability to capture transactions when they change, and integrate them in to the warehouse - along with maintaining batch or scheduled cycle refreshes. ...
Latest Answer: Snapshot is a fact table which describes about the state of things ina particular instance of time. It mainly involves semiadditive or nonadditive facts! ...
Latest Answer: Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. ...
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 ...
What is the difference between E-R modelling and Dimendional modelling? and what are semi additive facts?
View page [1] 2 3 Next >>
Go Top
