Logo

Navigation
  • Home
  • Services
    • ERP Solutions
    • Implementation Solutions
    • Support and Maintenance Solutions
    • Custom Solutions
    • Upgrade Solutions
    • Training and Mentoring
    • Web Solutions
    • Production Support
    • Architecture Designing
    • Independent Validation and Testing Services
    • Infrastructure Management
  • Expertise
    • Microsoft Development Expertise
    • Mobile Development
    • SQL Server Database and BI
    • SAP BI, SAP Hana, SAP BO
    • Oracle and BI
    • Oracle RAC
  • Technical Training
    • Learn Data Management
      • Business Intelligence
      • Data Mining
      • Data Modeling
      • Data Warehousing
      • Disaster Recovery
    • Learn Concepts
      • Application Development
      • Client Server
      • Cloud Computing Tutorials
      • Cluster Computing
      • CRM Tutorial
      • EDI Tutorials
      • ERP Tutorials
      • NLP
      • OOPS
      • Concepts
      • SOA Tutorial
      • Supply Chain
      • Technology Trends
      • UML
      • Virtualization
      • Web 2.0
    • Learn Java
      • JavaScript Tutorial
      • JSP Tutorials
      • J2EE
    • Learn Microsoft
      • MSAS
      • ASP.NET
      • ASP.NET 2.0
      • C Sharp
      • MS Project Training
      • Silverlight
      • SQL Server 2005
      • VB.NET 2005
    • Learn Networking
      • Networking
      • Wireless
    • Learn Oracle
      • Oracle 10g
      • PL/SQL
      • Oracle 11g Tutorials
      • Oracle 9i
      • Oracle Apps
    • Learn Programming
      • Ajax Tutorial
      • C Language
      • C++ Tutorials
      • CSS Tutorial
      • CSS3 Tutorial
      • JavaScript Tutorial
      • jQuery Tutorial
      • MainFrame
      • PHP Tutorial
      • VBScript Tutorial
      • XML Tutorial
    • Learn Software Testing
      • Software Testing Types
      • SQA
      • Testing
  • Career Training
    • Career Improvement
      • Career Articles
      • Certification Articles
      • Conflict Management
      • Core Skills
      • Decision Making
      • Entrepreneurship
      • Goal Setting
      • Life Skills
      • Performance Development
      • Personal Excellence
      • Personality Development
      • Problem Solving
      • Relationship Management
      • Self Confidence
      • Self Supervision
      • Social Networking
      • Strategic Planning
      • Time Management
    • Education Help
      • Career Tracks
      • Essay Writing
      • Internship Tips
      • Online Education
      • Scholarships
      • Student Loans
    • Managerial Skills
      • Business Communication
      • Business Networking
      • Facilitator Skills
      • Managing Change
      • Marketing Management
      • Meeting Management
      • Process Management
      • Project Management
      • Project Management Life Cycle
      • Project Management Process
      • Project Risk Management
      • Relationship Management
      • Task Management
      • Team Building
      • Virtual Team Management
    • Essential Life Skills
      • Anger Management
      • Anxiety Management
      • Attitude Development
      • Coaching and Mentoring
      • Emotional Intelligence
      • Stress Management
      • Positive Thinking
    • Communication Skills
      • Conversation Skills
      • Cross Culture Competence
      • English Vocabulary
      • Listening Skills
      • Public Speaking Skills
      • Questioning Skills
    • Soft Skills
      • Assertive Skills
      • Influence Skills
      • Leadership Skills
      • Memory Skills
      • People Skills
      • Presentation Skills
    • Finding a Job
      • Etiquette Tips
      • Group Discussions
      • HR Interviews
      • Interview Notes
      • Job Search Tips
      • Resume Tips
      • Sample Resumes
 

Rules to Use With Your Data Warehouse

By Exforsys | on February 5, 2007 |
Data Warehousing

Rules to Use With Your Data Warehouse

Once a company has successfully implemented their data warehouse, it is important for them to establish rules and regulations with which to use it. While different companies will have different rules when it comes to handling their data warehouses, their are some general principles that you will want to pay attention to.

These principles will not only make using your data warehouse easier, but it will also allow the organization to use it much more efficiently. The very first rule of thumb is to realize that data warehouses are challenging to use. Many experts say that at least 30% of the info they give out may not be consistent.

One of the most problematic things about this is the company may not notice the error if they are dealing with an operational unit that is transaction based. Despite this, this error percentage should not be allowed in the data warehouse. When you consider the fact that many large scale data warehouses can cost millions of dollars to purchase and implement, and error percentage of 30% is not acceptable. To solve this problem, it is important for companies to analyze their data carefully before making decisions that are based on it. It is unwise to just accept data as it is, without carefully looking 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 a half truth. Knowledge that is stored and unused is potential power. Companies will want to perform an analysis each day of the databases that are connected to the data warehouse. To understand the data, the analysts must be able to find relationships among numerous systems. Once these relationships are found, they must be maintained when the data is moved within the data warehouse. The implementation of a data warehouse will often require the user to make some modifications to the schema of the database.

If the user does not understand the various relationships among the systems, they may be prone to generating errors that could compromise the accuracy and efficiency of the system. Another important rule of thumb is to learn how to find entities that are equivalent or equal to each other. One of the most common problems that can occur in a data warehouse is when the same pieces of data appear in various parts of the system with different names. For instance, two departments within the organization may be helping one customer, but the name of the department may be placed in the system twice under different names.

One name could be spelled out, and the other name could be an abbreviation. This can create serious problems in the system if it is not corrected, and the best way to solve this problem is to use a data transformation tool. Because many large companies and organizations are comprised of many different departments, serious problems can arise when each them decides to store information in a different way. One of the situations where this occurs frequently is during mergers. To avoid this problem, companies will want to establish a standard database structure. This will make mergers much easier when they occur.

Perhaps one of the most important principles of data warehousing is to use metadata in a way that supports the quality of the data within the data warehouse. Metadata can be defined as "the data about data." It is the data which describes the data within the data warehouse.

One of the biggest challenge that companies will face is trying to harmonize the metadata across multiple vendor tools. To deal with this issue, companies will want to make sure they generate the metadata and use it for interfaces or other products. Look for vendors who are able to integrate metadata from numerous sources that are disparate.

It is also important for companies to make sure they choose the right data transformation products. A data transformation product is a device that extracts, cleans, and loads data into the data warehouse. It will also record a history of this process. The data transformation product is crucially important, and companies must choose the product carefully.

« « The Disadvantages of a Data Warehouse
Data Warehouse Issues » »

Author Description

Avatar

Editorial Team at Exforsys is a team of IT Consulting and Training team led by Chandra Vennapoosa.

Ads

Free Training

RSSSubscribe 416 Followers
Ads
  • Popular
  • Recent
  • Maintaining Records Within a Data Warehouse

    September 15, 2006 - 0 Comment
  • Fundamental Themes For Your Data Warehouse

    February 8, 2007 - 0 Comment
  • Data Warehousing Methods

    August 22, 2006 - 0 Comment
  • Advantages and Disadvantages to Using a Data Warehouse

    September 15, 2006 - 0 Comment
  • What You Should Know About Building a Data Warehouse

    February 10, 2007 - 0 Comment
  • Data Warehouse Design Strategies

    August 27, 2006 - 0 Comment
  • The Difference Between Data Mart and Data Warehouse

    September 15, 2006 - 0 Comment
  • How To Rate Your Data Warehouse

    February 10, 2007 - 0 Comment
  • How To Assess Your Data Warehouse

    August 30, 2006 - 0 Comment
  • Historical Information About Data Warehouses

    January 31, 2007 - 0 Comment
  • Data Warehouses Non Technical Issues

    June 23, 2007 - 0 Comment
  • How To Evaluate The Software For your Data Warehouse

    February 15, 2007 - 0 Comment
  • Understanding The Challenges of Using Data Warehouses

    February 15, 2007 - 0 Comment
  • Understanding Quality Management For Data Warehouses

    February 13, 2007 - 0 Comment
  • Creating an Efficient Process for Data Warehouses

    February 13, 2007 - 0 Comment
  • How Does a Data Warehouse Differ From a Database

    February 11, 2007 - 0 Comment
  • How Data Is Stored Within a Data Warehouse

    February 11, 2007 - 0 Comment
  • How To Rate Your Data Warehouse

    February 10, 2007 - 0 Comment
  • What You Should Know About Building a Data Warehouse

    February 10, 2007 - 0 Comment
  • Fundamental Themes For Your Data Warehouse

    February 8, 2007 - 0 Comment

Exforsys e-Newsletter

ebook
 

Related Articles

  • Data Warehouses Non Technical Issues
  • How To Evaluate The Software For your Data Warehouse
  • Understanding The Challenges of Using Data Warehouses
  • Understanding Quality Management For Data Warehouses
  • Creating an Efficient Process for Data Warehouses

Latest Articles

  • Project Management Techniques
  • Product Development Best Practices
  • Importance of Quality Data Management
  • How to Maximize Quality Assurance
  • Utilizing Effective Quality Assurance Strategies
  • Sitemap
  • Privacy Policy
  • DMCA
  • Trademark Information
  • Contact Us
© 2021. All Rights Reserved.IT Training and Consulting
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy
Necessary Always Enabled