Scribd Logo
Upload

Welcome to Scribd!

  • 88 views

    Enterprise Data Warehouse Testing Checklist

    Uploaded by

    email2rai
    The document outlines an enterprise data warehouse testing approach with 4 stages: 1) validating data from source to staging, 2) validating data from staging to the data vault, 3) validating data from the data vault to data marts, summary tables, and prompts, and 4) validating reports generated from data marts, summary tables, and prompts in Hyperion/OBIEE. Each stage includes structure, load process, count, duplicate record, and business scenario validations.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Enterprise Data Warehouse Testing Checklist

    Uploaded by

    email2rai
    88 views1 page
    The document outlines an enterprise data warehouse testing approach with 4 stages: 1) validating data from source to staging, 2) validating data from staging to the data vault, 3) validating data from the data vault to data marts, summary tables, and prompts, and 4) validating reports generated from data marts, summary tables, and prompts in Hyperion/OBIEE. Each stage includes structure, load process, count, duplicate record, and business scenario validations.

    Original Description:

    Data Warehouse Testing Checklist

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines an enterprise data warehouse testing approach with 4 stages: 1) validating data from source to staging, 2) validating data from staging to the data vault, 3) validating data from the data vault to data marts, summary tables, and prompts, and 4) validating reports generated from data marts, summary tables, and prompts in Hyperion/OBIEE. Each stage includes structure, load process, count, duplicate record, and business scenario validations.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    88 views1 page

    Enterprise Data Warehouse Testing Checklist

    Uploaded by

    email2rai
    The document outlines an enterprise data warehouse testing approach with 4 stages: 1) validating data from source to staging, 2) validating data from staging to the data vault, 3) validating data from the data vault to data marts, summary tables, and prompts, and 4) validating reports generated from data marts, summary tables, and prompts in Hyperion/OBIEE. Each stage includes structure, load process, count, duplicate record, and business scenario validations.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 1

    Enterprise Data Warehouse (EDW) Testing Approach

    1. Source to Staging Validations


    - Database tables structure validations – Staging tables
    - ETL load process validation – Source to Staging (Initial and Incremental)
    - Initial load count and data validations – Source to Staging
    - Initial load duplicate records validation – Source to Staging
    - Incremental load count and data validations – Source to Staging
    - Incremental load duplicate records validation – Source to Staging
    - Initial and Incremental business scenarios validations – Source to Staging
    - Metadata table validations – Source to Staging
    2. Staging to Data Vault Validations
    - Database tables structure validations – Data Vault tables
    - ETL load process validation – Source to Staging (Initial and Incremental)
    - Initial load count and data validations – Staging to Data Vault
    - Initial load duplicate records validation – Staging to Data Vault
    - Incremental load count and data validations – Staging to Data Vault
    - Incremental load duplicate records validation – Staging to Data Vault
    - Initial and Incremental business scenarios validations – Staging to Data Vault
    - Metadata tables validations --– Staging to Data Vault
    3. Data Vault to Data Mart/Summary tables/Prompt Validations
    - Database tables structure validations – Data mart/Summary/Prompt tables
    - ETL load process validation – Source to Staging (Initial and Incremental)
    - Initial load count and data validations – Data Vault to Data mart/Summary/Prompt
    - Initial load duplicate records validation – Data Vault to Data mart/Summary/Prompt
    - Incremental load count and data validations – Data Vault to Data mart/Summary/Prompt
    - Incremental load duplicate records validation – Data Vault to Data mart/Summary/Prompt
    - Initial and Incremental business scenarios validations – Data Vault to Data
    mart/Summary/Prompt
    - Metadata tables validations --– Staging to Data Vault
    4. Data Mart/Summary tables/Prompt to Hyperion/OBIEE Reports Validations:
    - Reports Layout validations
    - Reports Functionality validations
    - Reports Data validations
    - Reports duplicate records validations
    - Reports security validations (Manual Check - based on user type (National, State, County)
    - Reports Performance validation (Manual check)

    You might also like