Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Tuesday, 16 July 2013

Methods of DataWarehouse

By on 12:52:00

Most organizations agree that data warehouses are a useful tool. They benefit from the ability to store and analyze the data, and this can allow them to make sound business decisions. It is also important for them to ensure proper dissemination of information, and it should be easy to access by people who are responsible for making decisions.

There are two elements that make up a data warehouse environment, and this is a supply and staging. It can also be known as a staging area acquisitions. It consists of ETL processes, and once the data has been prepared, it will be sent to the display area.

When data is placed within the display area, a number of programs analysis and consideration. While many organizations agree on the overall goal of data warehouses, may approach to build these institutions vary. Try to use data clusters alone is not a good approach, because they are oriented departments. In addition, we will try to use data clusters alone are ineffective, and it will reach to a number of problems in the long term. There are two techniques for building data warehouses that have become very popular. This is the Kimball Bus Architecture and corporate information factory.

With technology Kimball, will convert the raw data and refined within the staging area. It is important to make sure properly handled data during this step. During the staging process, and will be withdrawn raw data from the source systems. While some of the staging operations may be centralized, and will be distributed to others. The display area has a dimensional structure, and this model will have the same information as a standard model. However, it will be easier to use, and it will display information that is summarized.

Will create a three-dimensional model through business process. Departments within the organization does not play a role in this. Data will be populated once it is placed inside a warehouse dimensions, not depending on the various departments that may make up the organization. When placed inside the warehouse business processes, the system will become highly efficient. Data warehouse approach popular following that you will want to become familiar with is the corporate information factory. Another name for this technique is the approach EDW. Will be the format of the data that is extracted from the source.

In the CIF, the data warehouse is used to hold the record data warehouses, and it may also have specific data warehouses that are designed to extract the data. May be designed for the populations of specific data circuits, and it may be the summary data which is in the form of dimensional structure. The data can be obtained from the data warehouse atomic standard. While there are some similarities between these techniques, there are some notable differences as well.

One of the fundamental differences between these two technologies is the basis of data normalization. With the approach of Kimball, the data structures that must be obtained before displaying depends on the dimensions of the source data and transformation. In most cases, it was not required to store a duplicate of the data in each of the foundations and normalized dimensions. It is believed many of the people who choose to use a normalized data structure that is faster than the dimensional structure, but they often fail to take the ETL into account.

Another thing that separates the two approaches is the management of data warehouse data (IAEA). With CIF, the data will be stored within the data warehouse Atomic normalization. In contrast, the method Kimball States that the atomic data should be placed in the context of the structure dimensions. When data is placed within the structure dimensions, it can be summed up in a wide variety of different ways.
It is important to make sure of the details of the information that you have so that users will be able to ask relevant questions. While most users do not put the focus on the details of the transaction and one offspring, they may want a summary of a large number of transactions. It is important for them to have the details so that they will not be able to answer important questions. Should be the approach you choose to be one which achieves your company's needs.


Post a Comment

Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)