Q&A Categories

Data-Warehouse-General

Why fact table is in normal form?

Why fact table is in normal form? '

Answers No Answers In: Data-Warehouse-General By: vikas [ Grey Star Level] Sep 6, 2010

Why should you put your data warehouse on a different system than your OLTP system

Why should you put your data warehouse on a different system than your OLTP system '

Answers No Answers In: Data-Warehouse-General By: jes [ Grey Star Level] Sep 6, 2010

Why are OLTP database designs not generally a good idea for a Data Warehouse

Why are OLTP database designs not generally a good idea for a Data Warehouse Answer posted by Shri Dana on 2005-04-06 19:04:05: OLTP cannot store historical information about the organization. It is used...

Answers No Answers In: Data-Warehouse-General By: claire [1 Grey Star Level] Sep 6, 2010

Wht r the data types present in bo?n wht happens if we implement view in the designer n report

Wht r the data types present in bo?n wht happens if we implement view in the designer n report '

Answers No Answers In: Data-Warehouse-General By: ramesh [ Grey Star Level] Sep 6, 2010

Which columns go to the fact table and which columns go the dimension table

Which columns go to the fact table and which columns go the dimension table Answered by Satish on 2005-04-29 08:20:29: The Aggreation or calculated value colums will go to Fac Tablw and details information...

Answers No Answers In: Data-Warehouse-General By: pooja [ Grey Star Level] Sep 4, 2010

Which automation tool is used in data warehouse testing?

Which automation tool is used in data warehouse testing? '

Answers No Answers In: Data-Warehouse-General By: sam [ Grey Star Level] Sep 4, 2010

What type of Indexing mechanism do we need to use for a typical datawarehouse

What type of Indexing mechanism do we need to use for a typical datawarehouse Answered by on 2005-03-23 01:45:54: bitmap index'

Answers No Answers In: Data-Warehouse-General By: claire [1 Grey Star Level] Sep 2, 2010

What Snow Flake Schema

What Snow Flake Schema Answered by Girinath.S.V.S on 2005-03-17 06:40:48: Snowflake schemas normalize dimensions to eliminate redundancy. That is, the dimension data has been grouped into multiple tables...

Answers No Answers In: Data-Warehouse-General By: pooja [ Grey Star Level] Sep 1, 2010

What is  degenerate dimension table?

What is  degenerate dimension table? '

Answers No Answers In: Data-Warehouse-General By: raju1587 [1 Grey Star Level] Sep 1, 2010

What is VLDB

What is VLDB Answered by Kiran on 2005-05-06 20:12:19: The perception of what constitutes a VLDB continues to grow. A one terabyte database would normally be considered to be a VLDB.'

Answers No Answers In: Data-Warehouse-General By: yogesh [ Grey Star Level] Aug 31, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]