|
| 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 |
 Related Questions Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. Latest Answer : A data warehouse design that enhances the performance of multidimensional queries on traditional relational databases. One fact table is surrounded by a series of related tables. Data is joined from one of the points to the center, providing a so-called ... Latest Answer : Real time Data warehousing means combination of hetrogenious databases and query and analysis purpose and Decisionmaking and reporting purpose. ... Latest Answer : create a procedure to load data into Time Dimension. The procedure needs to run only once to popullate all the data. For eg, the code below fills up till 2015. You can modify the code to suit the feilds in ur table.create or replace procedure ... Latest Answer : Raid 0 - Make several physical hard drives look like one hard drive. No redundancy but very fast. May use for temporary spaces where loss of the files will not result in loss of committed data. Raid 1- Mirroring. Each hard drive in the ... Information Packages(IP) are advanced by some author as a way of building dimensional models - e.g. star schemas. Explain what IPs are and Give an example of it\'s use in building a dimensional model. View Question | Asked by : Rokeya Begum Latest Answer : As The name interprets , Its not a Dimension. But rather can be Quoted as a primary key of the fact, usually a transational Fact like Premium, Money etc. It holds apart from the primary keys of the dimensions as foreign key in the fact.This key is not ... Read Answers (6) | Asked by : sharat What are the various attributes in time dimension, If this dimension has to consider only date of birth of a citizen of a country? Read Answers (1) | Asked by : naag Explain the flow of data starting with OLTP to OLAP including staging ,summary tables,Facts and dimensions. Latest Answer : Hi,
Slicing and Dicing is a feature that helps us in seeing the more detailed information about a particular thing.
For eg: You have a report which shows the quarterly based performance of a particular product. But you want to see it ... Read Answers (1) | Asked by : Sheen Latest Answer : Business Rulw is nothing but a transformation needs to be applied on the dataacoording to the user requirement. e.g. in trading system notional value willbe multiplication of(fund price* shares) ... Read Answers (1) | Asked by : Gunnampalli
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
