idanh79

 Profile Answers by idanh79 Questions by idanh79

• Dec 1st, 2009

Yes, you can do it by denormalization of the dimensions into one (and wide) dimension, it is depends of your needs.Idan Halfon

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 25th, 2008

Yes right said both model are designed for different purpose , I think star schema is very informative for business users unlike snowflake which is bit complicated with lot of small , small tables. If...

Answer Question  Select Best Answer

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 instead of one large table. For example, a product dimension table in a star schema might be normalized into a products table, a product_category table, and a product_manufacturer table in a snowflake schema. While this...

prodyot.sarkar

 Profile Answers by prodyot.sarkar Questions by prodyot.sarkar

• May 13th, 2010

Snow-flake schema is a logical arrangement of tables in dimensional modeling where a centralized fact table references number of other dimension tables; however, those dimension tables are further nor...

harshadapj

 Profile Answers by harshadapj Questions by harshadapj

• Jul 22nd, 2008

Closely related to the star schema, the snowflake schema is represented by centralized fact tables which are connected to multiple dimensionsIn the snowflake schema, however, dimensions are normalized...

Answer Question  Select Best Answer

Answered by Puneet on 2005-05-07 04:24:28: Data mining is a process of extracting hidden trends within a datawarehouse. For example an insurance dataware house can be used to mine data for the most high risk people to insure in a certain geographial area.

kumarram

 Profile Answers by kumarram Questions by kumarram

• Jun 11th, 2010

Data mining is the concept of extracting information from large data bases likes data wharehouse.

raj.rajeev15

 Profile Answers by raj.rajeev15 Questions by raj.rajeev15

• Sep 13th, 2009

Datamining is nothing but a science of finding information from databases or datasets. 

Answer Question  Select Best Answer

siraj khan

• Aug 6th, 2007

ODS means Operational Data store. ODS & Staging layer are the two layers between the source and the target datbases in the data warehouse..ODS is used to store the recent data.

chandrarekha

• May 8th, 2007

ODS is defined as an integrated view of operational data sources designed to support operational monitoring.

Answer Question  Select Best Answer

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

kamesh

• Jan 30th, 2018

Basically Fact table contain Index keys of the dimension/lookups tables of the measures so when ever we have the keys in the table it implies itself the fact table is in Normal For.

j123

• Jun 9th, 2013

Foreign keys of facts tables are primary keys of Dimension tables. It is clear that fact table contains columns which are primary key to other table that itself make normal form table.

Answer Question  Select Best Answer

vijay

• May 25th, 2017

While loading the data from Source to Target, if we are removing unwanted data or converting inconsistent data to consistent format is data clensing

TimeBeing

• Jan 25th, 2017

Data Cleansing is the process of converting inconsistent data into consistent data and removing unwanted data.

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

Vamshidhar

 Profile Answers by Vamshidhar Questions by Vamshidhar

• Jan 14th, 2009

Conformed Dimensions are used to connect two fact tables.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 20th, 2008

As comment by lot of DWH gurus above, two fact tables can be connected only using conformed dimension, defination of conformed dimension:if one primary key of dimension is defined in two fact tables it is called conformed dimension.

Answer Question  Select Best Answer

sharuvijay

 Profile Answers by sharuvijay Questions by sharuvijay

• Jan 29th, 2009

Data is stored in DW in a relational, aggregatted (if needed), denormalized fashion where the data can be easily analysed.

sixto.dsilva

 Profile Answers by sixto.dsilva Questions by sixto.dsilva

• Sep 11th, 2008

Data will stored in fact's and dimensional tables, the relational database can be Oracle, Informatic or netezza, it purely depends upon the company which technology they want to go for.

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

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

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

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

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

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