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

Tuesday, 16 July 2013

Rules of Datawarehouse


By on 12:43:00

Once the company has successfully carried out their own data warehouse, it is important for them to establish rules and regulations to be used. While different companies will have different rules when it comes to dealing with their own data warehouses, they are some general principles that you will need to pay attention to.

These principles not only make using your own data warehouse easier, but also allow the organization to be used much more efficiently. Very first rule of thumb is to realize that data warehouses are a challenge to use. And many experts say that at least 30% of the information you give may not be consistent.

One of the most problematic things about this is that the company may not notice the error if they are dealing with an operational unit to be based on the transaction. In spite of this, we should not allow this error rate in the data warehouse. When you consider the fact that many of the stores data on a large-scale can cost millions of dollars to purchase and implement, and 30% error rate is unacceptable. To resolve this issue, it is important for companies to analyze their data carefully before making decisions that are based on it. It is unwise to simply accept the data as it is, without looking carefully for errors or other problems.

The second rule of data warehouses is to understand the data that is stored. It has been said that knowledge is power, but this is only half the truth. Knowledge that is stored and unused is power potential. The companies want to make every day analysis of the databases that are connected to the data warehouse. To understand the data, you should be able to find the relationships between systems analysts are numerous. Once found on these relationships, and must be preserved when transferring data within the data warehouse. The implementation of a data warehouse requires often the user to make some modifications to the schema of the database.

If the user does not understand the relationships between the different systems, they may be prone to generate errors that can adversely affect the accuracy and efficiency of the system. Another important rule of thumb is to learn how to find the entities that are equal to or equal to each other. One of the most common problems that can occur in the data warehouse is when they show the same piece of data in different parts of the machine with different names. For example, two of the departments within the organization may be helping one client, but the name of the Ministry shall not be placed in the system twice under different names.
One name can be provided, and can be another name abbreviation. This can create serious problems in the system if it is not corrected, the best way to solve this problem is to use a data conversion tool. Because many consist of large companies and institutions from many different departments, and can be serious problems arise when each of them decides to store the information in a different way. One of the cases in which this occurs often through mergers. To avoid this problem, companies want to create a standard database structure. This will make it much easier integration when they occur.

Perhaps one of the most important principles of data storage is the use of meta data in a manner supportive of the quality of data within the data warehouse. The metadata can be defined as "data about data." It is data that describes the data within the data warehouse.

One of the biggest challenges facing companies will try to reconcile the metadata across multi-vendor tools. To deal with this problem, the companies want to make sure they generate and use metadata interfaces or other products. Look for vendors who are able to integrate metadata from a variety of sources that are mixed.

It is also important for companies to make sure they choose the right products and data conversion. Data Conversion product is a device that extracts, cleans, and load the data into the data warehouse. It will also record the date of this process. Product data transfer is very important, and companies must carefully choose the product.

0 comments:

Post a Comment

Blog Archive

Labels

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 11.1.1.7.1 (1) OBIA 7.9.6.3 (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)