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

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

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

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

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

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

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

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

TimeBeing

• Jan 25th, 2017

A Dimension table which is used by multiple Fact Tables is called "Confirmed Dimension".

matrixfree

• May 5th, 2016

Are the conformed dimensions the same as Common dimensions ? In Cognos Framework Manager ?

Answer Question  Select Best Answer

kamesh

• Jan 30th, 2018

A Dimension which is derived from the fact table and doesnt have its own dimension table A degenerate dimension is a transaction based number. A degenerated dimensions are often called as textual fact...

TimeBeing

• Jan 25th, 2017

A Dimension table which have the values of Fact table is called "De-Generated Dimension".

Answer Question  Select Best Answer

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.

munavar.shaik

 Profile Answers by munavar.shaik Questions by munavar.shaik

• Jan 20th, 2011

A fact table is an entity representing the numerical measurements or metrics or facts of the business Eg: Billings table,Bookings table,Accounts tableA dimension table is the entity describing th...

ashwinijawalgekar

 Profile Answers by ashwinijawalgekar Questions by ashwinijawalgekar

• Jun 9th, 2010

Fact  table is a normalized table divided in to 2 parts  Link to all dimension tables -> First part of fact table contains set of foreign keys which links to the respective dimension t...

Answer Question  Select Best Answer

praveen

• Jun 26th, 2017

how do you update when customer changed address: on 06-26-2016 -------------- 101,101_address1, on 06-26-2017, customer 101 moved to new loc and 102 added ---------------- 101,101_Address2 ...

TimeBeing

• Jan 25th, 2017

There are 2 types of data loading.
1. Initial Loading: Data loading for the first time in to Table/Database is called Initial Loading.

2. Incremental Loading: Inserting new data and updating existing data which comes with new values is Incremental Loading.

Answer Question  Select Best Answer

bryan

• Nov 17th, 2014

I dont see Boeings TwisterDataFramework. It is used extensively in the US Government and I thought it would be reviewed here.

Ashutosh Shukla

• May 4th, 2012

1. Oracle Warehouse Builder (OWB) 11gR1 Oracle 2. Data Services XI 3.2 SAP Business Objects 3. IBM Information Server (Datastage) 9.1 IBM 4. SAS Data Integration Studio 4.21 SAS Institute 5. Pow...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

ankeshjain  

 Profile Answers by ankeshjain Questions by ankeshjain

• Member Since Aug-2008 | Aug 17th, 2008

---

1. Requirement gathering for BI reports
2. Identify the source databases
3. Designing source to target mappings
4. Designing DWH
5. Designing ETL jobs
6. Development of ETL jobs
7. Data load into DWH
 

Ravi Teja N

• Sep 16th, 2011

The steps used to develop a DWH are 1. Gathers Operational Source System 2. Data Staging Area 3. Data presentation Area 4. Data Access Tool Lets have a detailed information about each stage: Operat...

mohanbabu

• Aug 20th, 2011

We can create the dwh in two ways i.e
1. top down approach
2.bottom up approach

Improve Answer

Kamesh

• Jan 30th, 2018

ER represent the logical design technique that seeks to eliminated the data redundancy It shows the relationship between the data.
DM is a logical technique that seek to present the data in standard intuitive to allow high performance access.

Sreedhar Lokaray

• Nov 3rd, 2011

I think the answer the best suits this question is as below: Entity - Relationship Modelling:- Removes data redundancy. Ensures data consistency. Expresses relationship between the entities....

Answer Question  Select Best Answer

TimeBeing

• Jan 25th, 2017

Lookup for some related data in Database or Flatfiles or Database View based on key column

Johnson Weltch

• Dec 16th, 2016

This was great to know more about lookup table in database. You may also go through this informative article on look up table to get brief knowledge about Lookup table in database:
Lookup table in SQL Server at sqlmvp org

Answer Question  Select Best Answer

Ishu

• Feb 20th, 2015

SCD1: in SCD1, no history is maintained.
SCD2: whole history is maintained.
SCD3: just the current and last record is stored.

kalyan

• Nov 22nd, 2013

The value of dimensions is used change very rarely, That is called Slowly Changing dimensions.

they are 3 types

scd1
scd2
scd3

scd1:it used Replace the old values overwrite by new values
scd2:Creating Additional records
scd3:Its maintain just previous and recent

Answer Question  Select Best Answer

ETL is extraction,transformation and loading,ETL technology is used for extraction the information from the source database and loading it to the target database with the necessary transformations done in between.

rsp2709

 Profile Answers by rsp2709 Questions by rsp2709

• Jun 8th, 2009

ETL is a process that extracts data from one database, transforms it as per the destination database and loads it into another database. In the transformation process, data is actually standardized to...

jaggu_mandya

 Profile Answers by jaggu_mandya Questions by jaggu_mandya

• Jan 16th, 2008

Data Acquisition technique is now called ETL(Extraction, Transformation and Loading)Extraction-The process of extracting the data from various sources. Sources can be file system, database, XML file, ...

Answer Question  Select Best Answer

Answered by Hemakumar on 2005-04-12 05:40:50: Cognos BusinessObjects MicroStrategies Actuate

Bharath

• Aug 27th, 2014

Pentaho Data Analytics

Ravi

• Aug 21st, 2014

IntelliView INEA
MS-Excel
Business Objects (Crystal Reports)
Cognos (Impromptu, Power Play)
Microstrategy
MS reporting services(SSRS)
Informatica Power Analyzer
Hyperion (BRIO)
Oracle Express OLAP
Proclarity
SAS
Qlikview
Actuate
jasper reports
Tableau

Answer Question  Select Best Answer