SDET- QA Automation Techie

Full Stack QA Automation 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

Confirmed dimension in data warehouse

 Confirmed dimension in data warehouse   

What is a Confirmed dimension?

As we know that, a dimension table stores non-quantifying data. Dimensions will be used as a viewpoint in the analysis process. A data warehouse database contains integrated fact and dimension tables for different business lines.
In some cases based on business need, a dimension can be referred in multiple fact tables of different business lines. This type of dimension is called confirmed dimension.

Sometimes, two dimension tables have the same structure and with the same data. In that case, both dimensions are called as confirmed dimensions.

 Advantages of having this dimension:

  1. Only one data load
    Data load happens only for one dimension table. It is not required to load the same data into different databases/data marts.
  2. Data consistency
    It keeps the same data across all business lines. If any changes happen all no need worry about by individual business line users.
  3. Data redundancy
    As we are keeping data in a single, centralized table, the duplicate data won’t be available.
  4. Memory consumption
    If we keep the same data in individual tables for every business line, it consumes huge memory. But the process of using confirmed dimension table reduces the memory consumption also.
Examples for this type dimension:
In the banking sector, typically the data warehouse database contains all three major business lines such as Saving, Credit and Loan accounts.
For every data analysis, customer information is required. The bank stores all customer data in a single table called “customer” dimension.
This “customer” dimension reference to fact tables of Saving, Credit and Loan account data marts. So that all three data mart reports point the same dimension for customer details.
Confirmed dimension table in data warehouse example
Date dimension is an another example. Date dimension contains day, month and year along with a surrogate key.
All business area fact tables can have the reference with this dimension wherever calendar related report requires.
  • 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...
  • 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...
  • 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...

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