UrbanPro
true

Learn Oracle Database from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

Data Warehousing - End to End

Cognitior
13/01/2017 0 0

Data warehouse - An Idea

Subject Oriented - A data warehouse is subject oriented because it provides information around a subject rather than the organization's ongoing operations.

These subjects can be product, customers, suppliers, sales, revenue, etc.

A data warehouse does not focus on the ongoing operations, rather it focuses on modelling and analysis of data for decision making.

Integrated - A data warehouse is constructed by integrating data from heterogeneous sources such as relational databases, flat files, etc.

This integration enhances the effective analysis of data.

Time Variant - The data collected in a data warehouse is identified with a particular time period.

The data in a data warehouse provides information from the historical point of view.

Non-volatile - Non-volatile means the previous data is not erased when new data is added to it.

A data warehouse is kept separate from the operational database and therefore frequent changes in operational database is not reflected in the data warehouse.

Function of data warehouse tools and utilities

Data Extraction - Involves gathering data from multiple heterogeneous sources.

Data Cleaning - Involves finding and correcting the errors in data.

Data Transformation - Involves converting the data from legacy format to warehouse format.

Data Loading - Involves sorting, summarizing, consolidating, checking integrity, and building indices and partitions.

Refreshing - Involves updating from data sources to warehouse.

 

0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

Dynamic HyerText Markup Language (DHTML)
Dynamic HyerText Markup Language (DHTML) is a combination of Web development technologies used to create dynamically changing websites. Web pages may include animation, dynamic menus and text effects....

SQL (Structured Query Language)
SQL (Structured Query Language) is a standardized programming language used for managing relational databases and performing various operations on the data in them. Initially created in the 1970s, SQL...

R programming language
R is a programming language and software environment for statistical computing and graphics supported by the R Foundation for Statistical Computing. The R language is widely used among statisticians and...

Must know fact about DDL
Hello everyone, This is again for beginners, as a Trainer, it's my duty to educate the beginners/learners. Let's take an example below, --Assume we already have 'EMP' table with the columns- id,name,Sal Insert...

Chart
A chart is a set of coordinates When you make a chart you start with an empty, two-dimensional space, a vertical dimension (y) and a horizontal dimension (x) . You also have a data source. Your job is...
X

Looking for Oracle Database Classes?

The best tutors for Oracle Database Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Oracle Database with the Best Tutors

The best Tutors for Oracle Database Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more