Relational and dimensional data modeling
Asked By: sm_arunachalam | Asked On: Jul 22nd, 2008
2 answers
How can you say relational is normalized one and data warehouse i.E dimensional modeling is de-normalized one when both model follows the primary key concept in its table to store data
Answered by: Iftikhar Alam on: Apr 8th, 2012
Data obtain from transactional source which is normalized on 3NF. It has been staged and demoralized the data and after denationalization of data re-normalized on 2NF and 3NF. Therefore, It is called ...
Answered by: madhavig on: Feb 16th, 2010
Dimensional modeling usually does with 2NF for dimensions and 3NF for facts.
Dimensions are de-normalized for better query performance and for better understanding by business users.
Asked By: sm_arunachalam | Asked On: Jul 22nd, 2008
2 answers
How can you say relational is normalized one and data warehouse i.E dimensional modeling is de-normalized one when both model follows the primary key concept in its table to store data
Answered by: Iftikhar Alam on: Apr 8th, 2012
Data obtain from transactional source which is normalized on 3NF. It has been staged and demoralized the data and after denationalization of data re-normalized on 2NF and 3NF. Therefore, It is called ...
Answered by: madhavig on: Feb 16th, 2010
Dimensional modeling usually does with 2NF for dimensions and 3NF for facts.
Dimensions are de-normalized for better query performance and for better understanding by business users.
1) differences between dss and oltp.2) explain grouped cross tab.3) define surrogate key.4) what is iqd file.5) expalin reference cursor.
Asked By: vasanth kishore | Asked On: Oct 24th, 2006
5 answers
Answered by: rj_dwbi on: Apr 2nd, 2012
OLAP: 1). Store historical data of an organization 2). Data is used for BI/ business strategic decision OLTP 1). Real time transactional data 2). Data is used to have track of transaction details.
Answered by: sandeepbiswal on: Aug 2nd, 2010
DSS (Decission support system) which helps to take decission for the top executive people. It generally based on historical dataOLTP (Online trasnaction processing) system is the the system where day ...
5 answers
Answered by: rj_dwbi on: Apr 2nd, 2012
OLAP: 1). Store historical data of an organization 2). Data is used for BI/ business strategic decision OLTP 1). Real time transactional data 2). Data is used to have track of transaction details.
Answered by: sandeepbiswal on: Aug 2nd, 2010
DSS (Decission support system) which helps to take decission for the top executive people. It generally based on historical dataOLTP (Online trasnaction processing) system is the the system where day ...
No comments:
Post a Comment