SDET- QA Automation Techie

Software Testing Blog

  • Home
  • Training
    • Online
    • Self-Paced
  • Video Tutorials
  • Interview Skills
    • HR Interview Questions Videos
    • Domain Knowledge
  • Career Guidance
  • Home
  • Software Testing
    • Manual Testing Tutorials
    • Manual Testing Project
    • Manaul Testing FAQS
    • ISTQB
    • AGILE
  • Web Automation Testing
    • Java Programmng
    • Python Programmng
    • Selenium with Java
    • Selenium with Python
    • Robot Framework(Selenium with Python)
    • selenium with Cucumber
    • TestNG+IntelliJ
    • Mobile App Testing(Appium)
    • JMeter
  • API Automation Testing
    • Rest Assured API Testing (BDD)
    • Rest Assured API Testing (Java+ TestNG)
    • Robot Framework(Rest API Testing with Python)
    • Postman
    • SoapUI
    • API Testing(FAQ's)
  • SDET|DevOps
    • Continuos Integration
    • SDET Essentials
    • AWS For Testers
    • Docker
  • SQL
    • Oracle(SQL)
    • MySQL for Testers
    • NoSQL
  • Unix/Linux
    • UNIX TUTORIALS
    • Linux Shell Scripting
  • ETL Testing
    • ETL Data warehouse Tutorial
    • ETL Concepts Tools and Templates
    • ETL Testing FAQ's
    • ETL Testing Videos
  • Big Data Hadoop
  • Video Tutorials
  • ApachePOI Video Tutorials
  • Downloads
    • E-Books for Professionals
    • Resumes
  • Automation Essencials
    • Cloud Technologies
      • Docker For Testers
      • AWS For Testers
      • Sub Child Category 3
    • Java Collections
    • Selenium Locators
    • Frequently Asked Java Programs
    • Frequently Asked Python Programs
    • Protractor
    • Cypress Web Automation

Why data warehouse?

 Why data warehouse?   

Normally every organisation will have dedicated databases for every business line. And it keeps only current data in order to offer better performance in production environment.
In this internet world, every organization is trying to retain their customers which are necessary to sustain and grow in the current market. It’s a very big challenge to find and promote the right product to the right customer at the right time and currently, most of the companies are still struggling to implement this.
It can be possible only if we have the integrated and history of data in a single place for analysis since the analysis need to be done from different dimensions (customer, product, and geography) view to arriving the decisions.

An example of a quarterly analysis reports with integrated data from different location databases for a retail store.

A data warehouse,

  1. Maintains history of data
  2. Contains Integrated data (data from multiple business lines)
  3. Contains Heterogeneous data (data from different source formats)
  4. Contains Aggregated data
  5. Allows only select to restrict data manipulation
  6. Stores data in de-normalized format

Example:

Let’s take an example of a bank which maintains dedicated databases to store the data for Saving account , credit account, and loan account.
The bank is planning to launch a new product. The management team as come up with a strategy to promote this product to our existing customers. Also, it will be purely based on past performance on all three saving, credit and loan account sections.
The management wants to do more analysis on credit card utilization and settlement history, loan availing and repayment history in a single report.
This will be possible if all three data in a single database (data warehouse) and the historical data for every customer. Hence this data warehouse database can feed the data to analysis or reporting tool which gives good analysis information to make decisions.

Definition of a data warehouse

Subject-Oriented
  • DWH database contains data for the specific subjects where we could analyse the data from different subjects
dw definition subject
Integrated
  • Integrated from different business line databases
    dw definition integrated
Time-variant
  • A transactional database will contain only current data, but DWH database contains history of datadw definition timevariant
Non-volatile
  •  The CRUD operations allowed in transactional database, but in DWH database won’t allow making changes to maintain the historical datadw definition non volatile
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
  •  Stumble
  •  Digg
Email ThisBlogThis!Share to TwitterShare to Facebook
Newer Post Older Post Home
popup

Popular Posts

  • How To Explain Project In Interview Freshers and Experienced
    “ Describe an important project you’ve worked on ” is one of the most common questions you can expect in an interview. The purpose of a...
  • MANUAL TESTING REAL TIME INTERVIEW QUESTIONS & ANSWERS
    1. How will you receive the project requirements? A. The finalized SRS will be placed in a project repository; we will access it fr...
  • API/Webservices Testing using RestAssured (Part 1)
    Rest Assured : Is an API designed for automating REST services/Rest API's Pre-Requisites Java Free videos: https://www.you...

Facebook Page

Pages

  • Home
  • Resumes
  • Job Websites India/UK/US
  • ISTQB
  • Selenium with Java
  • E-Books for Professionals
  • Manual Testing Tutorials
  • Agile Methodology
  • Manual Testing Projects

Live Traffic

YouTube


Blog Visitors

Copyright © SDET- QA Automation Techie | Powered by Blogger
Design by SDET | Blogger Theme by | Distributed By Gooyaabi Templates