GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

Data Warehousing Concepts


Data Warehousing Concepts

Questions: 29
Comments: 85
 Data Warehousing Concepts Tags
 Showing Questions 1-10 of 29 Questions
[1] 2 3 Next >>
 Sponsored Links

 
 Data Warehousing Concepts
Sorting Options :  

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 ...
Read Answers (6) | Asked by : prasath

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. ...
Read Answers (5) | Asked by : prasad

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! ...
Read Answers (5) | Asked by : nitin khanna

Latest Answer: Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. ...
Read Answers (4) | Asked by : prasath

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?
Read Answers (4) | Asked by : amjad

View page [1] 2 3 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
Sponsored Links

 
Sponsored Links



 

 
 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape