Kalai

• Jul 29th, 2006

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 ?bott...

Loveojha

• May 18th, 2006

There can be actually three methodology as suggested by Ralph Kimball1. Top Down Approach (Build using a Big Bang Approach, which takes time and result won't be visible very quickly, but will be more ...

Answer Question  Select Best Answer

saivenkatesh

 Profile Answers by saivenkatesh Questions by saivenkatesh

• Jun 22nd, 2006

RalfKimball: he follows bottum-up approach i.e., first create individual Data Marts from the existing sources and then create Data Warehouse.BillImmon: he follows top-down approach i.e....

Mayee

• Jun 8th, 2006

Actually, the main difference is Kimball: fallows Dimentional ModellingInmon: fallows ER ModellingbyeMayee

Answer Question  Select Best Answer

bobby

• May 31st, 2006

hi venkateshdimension , measure, detail are objects type.data types are character, date and numeric

ravi

• Jan 13th, 2006

The different data types in business objects are:1. Character.2. Date.3. Long text.4. Number

Answer Question  Select Best Answer

Answered by sudhakar on 2005-05-09 18:32:18: star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy...

sk.rafee

 Profile Answers by sk.rafee Questions by sk.rafee

• Apr 26th, 2006

Star schema uses denormalized dimension tables,but in case of snowflake schema it uses normalized dimensions to avoid redundancy...

Guest

• Feb 13th, 2006

Star Schema                                &n...

Answer Question  Select Best Answer

Answered by Satish on 2005-04-29 08:20:29: The Aggreation or calculated value colums will go to Fac Tablw and details information will go to diamensional table.

ravi kumar guturi

• Mar 9th, 2006

Before broken into coloumns is going to the factAfter broken going to dimensions

sudhir

• Aug 4th, 2005

To add on, Foreign key elements along with Business Measures, such as Sales in $ amt, Date may be a business measure in some case, units (qty sold) may be a business measure, are stored in the fact table. It also depends on the granularity at which the data is stored

Answer Question  Select Best Answer

senthil kumar B

• Feb 13th, 2006

Degenerate Dimensions : If a table contains the values, which r neither dimesion nor measures is called degenerate dimensions.Ex : invoice id,empno

Balaji

• Jan 6th, 2006

in simple terms, the column in a fact table that does not map to any dimensions, neither it s a measure column.for e.g Invoice_no, Invoice_line_no in fact table will be a degenerate dimension (columns), provided if you dont have a dimension called invoice.

Answer Question  Select Best Answer

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.

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 9th, 2006

Very Large Database (VLDB)it is sometimes used to describe databases occupying magnetic storage in the terabyte range and containing billions of table rows. Typically, these are decision support systems or transaction processing applications serving large numbers of users. Cheers,Sithu

Muhammed Kamal

• Aug 30th, 2005

VLDB stands for Very Large Data Base, any database too large (normally more than 1TB) cosidered as VLDB.

Answer Question  Select Best Answer

J Lehew

• Aug 25th, 2005

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. &nb...

Answer Question  Select Best Answer

Kenneth

• Jul 18th, 2005

An DW is typically used most often for intensive querying . Since the primary responsibility of an OLTP system is to faithfully record on going transactions (inserts/updates/deletes), these operations will be considerably slowed down by the heavy querying that the DW is subjected to.

Nirav

• May 15th, 2005

Data Warehouse is a part of OLAP (On-Line Analytical Processing). It is the source from which any BI tools fetch data for Analytical, reporting or data mining purposes. It generally contains the data...

Answer Question  Select Best Answer