Anindya1281

 Profile Answers by Anindya1281 Questions by Anindya1281

• Jun 5th, 2011

surrogate key is a substituted key for the business key in data warehouseThis is generated while the loading process (ETL)attributes of surrogate key1) It has the same granularity of the Business Key ...

bcsandip

 Profile Answers by bcsandip Questions by bcsandip

• Oct 8th, 2010

Along with Jeff's answer, the surragate key also distinguish 2 records with the same combined primary key in the denormalized DWH tables where history is maintained.

Answer Question  Select Best Answer

kamesh

• Jan 30th, 2018

A join is linked with only only one dim and one fact is called star schema
A join is linked with more than one dimension is called Snow flake schema.

sunny

• Jul 5th, 2013

star schema: When dimension table contains less number of rows, we can go for Star schema.In this Both Dimension and Fact Tables are in De-Normalized form.Good for datamarts with simple relationships ...

Answer Question  Select Best Answer

Kamlesh

• Jun 22nd, 2017

Yes dimension table can contain numeric value. i.e. Product dimension can have price, quantity as numeric values

uday

• Aug 17th, 2016

Yes, A dimension Table can have numeric data types and information. For example. the surrogate key columns which are numeric. and in a scenario if a product has min discount and max discount column...

Answer Question  Select Best Answer

rajnsuccess

 Profile Answers by rajnsuccess Questions by rajnsuccess

• Jan 10th, 2011

Dimensional Modelling is a design concept used by many data warehouse desginers to build thier datawarehouse. In this design model all the data is stored in two types of tables - Facts table and Dimen...

kevin0209

 Profile Answers by kevin0209 Questions by kevin0209

• Aug 30th, 2010

Dimension modelling is a logical design technique that seeks to present the data in a standard framework that allows users for high performance accesss.

Answer Question  Select Best Answer

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 complete individual data warehouses which are usually smaller than the corporate data warehouse.

ashwinijawalgekar

 Profile Answers by ashwinijawalgekar Questions by ashwinijawalgekar

• Jun 9th, 2010

Data Marts: Data Mart is a subset of Data Warehousing. Depending upon the management decision the warehouse devides into smaller part according to their respective subject. eg sales is a data mart of xyz warehouse

spatnam

 Profile Answers by spatnam Questions by spatnam

• Dec 9th, 2008

Datamart is a subset of datwarehouse. Data mart deals with single line of business like Sales, Purchase etc. Size of data will be less when compared to Datawarehouse.Some of the different types of datamart are Depndant datamart , Independant datamart, Hybrid datamart

Answer Question  Select Best Answer

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. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)

kamesh

• Jan 30th, 2018

A join is linked with only one dimension and one fact is called Star chema

TimeBeing

• Jan 25th, 2017

A Fact table is surrounded by multiple Dimension tables and which is look like STAR in graphical design is called "STAR Schema".

Answer Question  Select Best Answer

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 easier and more efficient to run queries over data that originally came from different sources. Typical relational databases are designed for on-line transactional processing (OLTP) and do not meet the...

chandrasekhar

• Mar 10th, 2017

The complete process of ETL activities (Extract, Transform and Load) and BI (Business Intelligence for generating reports) are called Data Warehousing.

TimeBeing

• Jan 25th, 2017

Datawarehousing is a process of Designing a database Schema, ETL process and Reporting.

Answer Question  Select Best Answer

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 recovery is necessary   OLAP Current and historical data Long database transactions Batch update/insert/delete Denormalization is promoted Low...

ram

• Aug 30th, 2016

OLTP: Original Source of data
Running on fundamental business task

OLAP: Data coming from various OLTP sources
Problem Solving, Decision Making

Pravin

• Jan 16th, 2015

Very useful answer.
thanks.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: saravanan

• Dec 2nd, 2005

---

Surrogate key is a unique identification key, it is like an artificial or alternative key to production key, bz the production key may be alphanumeric or composite key but the surrogate key is always single numeric key. Assume the production key is an alphanumeric field if you create an index for this fields it will occupy more space, so it is not advisable to join/index, bz generally all the datawarehousing fact table are having historical data. These factable are linked with so many dimension table. if it's a numerical fields the performance is high

P.Manideep

• Oct 29th, 2017

Surrogate key is system generated key. It is a column or set of columns declared as primary key instead of real of natural key.

Anukul Thawarey

• Aug 8th, 2017

Just to add on to this point, we can also have date stamp as in the format (yyyymmdd) which is actually an 4 Byte unsigned integer to keep track of the historical data. This date stamp column can also be considered as an surrogate key.

Improve Answer