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 Basics


Data Warehousing Basics

Questions: 106
Comments: 496
 Data Warehousing Basics Tags
 Showing Questions 1-10 of 106 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 Data Warehousing Basics
Sorting Options :  

don't know 
Latest Answer: And it is derived from primary key. ...
Read Answers (17) | Asked by : Minish Cherian

Latest Answer: It is logical design techniques and visual techinques it can be contain aggregate table, dimension table, fact table ...

Answered by swetha on 2005-03-30 12:00:33: OLTP  Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction 
Latest Answer: Thanks Jyothsna....... ...

Data Mart is a segment of a data warehouse that can provide data for reporting and analysis on a section, unit, department or operation in the company, e.g. sales, payroll, production. Data marts are sometimes 
Latest Answer: A Data Mart is the subset of the data warehouse that caters the needs of a specific functional domain.examples of functional domains can be given as Sales, Finance, Maketing, HR etc. ...

Latest Answer: There are four methods in which one can build a datawarehouse.1. Top-Down (Emphasizes the DW. )2. Bottom-Up (Emphasizes data marts.)3. Hybrid (Emphasizes DW and data marts; blends “top-down” and “bottom-up” methods.)4. Federated (Emphasizes the need to ...
Read Answers (13) | Asked by : Srinu

Data Warehouse is a repository of integrated information, available for queries and analysis. Data and information are extracted from heterogeneous sources as they are generated....This makes it much 
Latest Answer: Data Warehousing is Relational Database which is specially designed for analysis processing rather then for querying and transactional processing. ...

Latest Answer: By far, the best ETL tool on the market is Hummingbird Genio.Hummingbird is a division of OpenText, they make, among other things, connectivity and ETL software. ...

Answer posted by Chintan on 2005-05-22 18:46:03: A table in a data warehouse whose entries describe data in a fact table. Dimension tables contain the data from which dimensions are created. 
Latest Answer: Fact table is the one which contains measures of interest at most granular level.These values are numeric.Ex:sales amount would be a measure .Each dimension table has a single-part primary which exactly corresponds to one of the components of  multiparty ...

Latest Answer: ODS means Operational Data store. ODS & Staging layer are the two layers between the source and the target datbases in the data warehouse..ODS is used to store the recent data. ...

Latest Answer: A dimension which can be shared with multiple fact tables such dimensions are know as conformed dimension. ...

View page [1] 2 3 4 5 6 7 8 9 10 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