Test Cases
| |
Mapping doc validation
|
Verify mapping doc whether corresponding ETL information is provided or not. Change log should maintain in every mapping doc.
|
Validation
|
1. Validate the source and target table structure against corresponding mapping doc.
2. Source data type and target data type should be same
3. Length of data types in both source and target should be equal
4. Verify that data field types and formats are specified
5. Source data type length should not less than the target data type length
6. Validate the name of columns in the table against mapping doc.
|
Constraint Validation
|
Ensure the constraints are defined for specific table as expected
|
Data consistency issues
|
1. The data type and length for a particular attribute may vary in files or tables though the semantic definition is the same.
2. Misuse of integrity constraints
|
Completeness Issues
|
1. Ensure that all expected data is loaded into target table.
2. Compare record counts between source and target.
3. Check for any rejected records
4. Check data should not be truncated in the column of target tables
5. Check boundary value analysis
6. Compares unique values of key fields between data loaded to WH and source data
|
Correctness Issues
|
1. Data that is misspelled or inaccurately recorded
2. Null, non-unique or out of range data
|
Transformation
|
Transformation
|
Data Quality
|
1. Number check: Need to number check and validate it
2. Date Check: They have to follow date format and it should be same across all records
3. Precision Check
4. Data check
5. Null check
|
Null Validate
|
Verify the null values, where “Not Null” specified for a specific column.
|
Duplicate Check
|
1. Needs to validate the unique key, primary key and any other column should be unique as per the business requirements are having any duplicate rows
2. Check if any duplicate values exist in any column which is extracting from multiple columns in source and combining into one column
3. As per the client requirements, needs to be ensure that no duplicates in combination of multiple columns within target only
|
Date Validation
|
Date values are using many areas in ETL development for
1. To know the row creation date
2. Identify active records as per the ETL development perspective
3. Identify active records as per the business requirements perspective
4. Sometimes based on the date values the updates and inserts are generated.
|
Complete Data Validation
|
1. To validate the complete data set in source and target table minus a query in a best solution
2. We need to source minus target and target minus source
3. If minus query returns any value those should be considered as mismatching rows
4. Needs to matching rows among source and target using intersect statement
5. The count returned by intersect should match with individual counts of source and target tables
6. If minus query returns of rows and count intersect is less than source count or target table then we can consider as duplicate rows are existed.
|
Data Cleanness
|
Unnecessary columns should be deleted before loading into the staging area.
|
Pages
- Home
- Manual Testing Tutorials
- Manual Testing Materials
- Manual Testing Interview Q & A
- ISTQB
- UNIX /Linux
- SQL
- Agile Methodology
- Selenium with Java
- Selenium with Python
- Automation Testing Materials
- API Testing
- Advanced Java
- Cypress Tutorials
- ETL Testing Documents
- ETL Testing videos
- Big Data Hadoop
- SDET Essentials
- Miscellaneous Topics
- Career Guidance
- Mock Interviews
- Resume Templates
- YouTube Videos
- Udemy Courses
- Online Training
ETL Test Scenarios and Test Cases
Popular Posts
- How To Explain Project In Interview Freshers and Experienced
- Selenium Frequently Asked Questions & Answers Part-6
- API/Webservices Testing using RestAssured (Part 1)
- How to use HashMap in Selenium WebDriver
- Java Programs for Selenium
- Manual & Automation Testing Free Video Tutorials | YouTube Playlists
- ETL Test Scenarios and Test Cases
- How to Generate Extent Report Version 4 in TestNG Framework
- Python Interview Questions and Answers Part-1
Followers
Labels
a Software Tester or a Developer?
(1)
Adhoc Testing
(1)
Agile
(33)
Agile Team
(1)
Agile Testing
(2)
apache poi
(1)
Appium
(1)
Appium FAQ'S
(1)
Banking Domain
(1)
Core Java scripts
(4)
Cross-browser Web Testing
(1)
How to use Java Collections
(1)
ISTQB
(1)
ISTQB Sample Question Paper
(10)
Java
(5)
Java Interview Questions
(2)
Java Programs for Selenium
(1)
Jira
(1)
Linux
(7)
Manual Testing
(48)
Manual Testing Interview Questions
(2)
Maven Questions & Answers
(1)
Mobile Application
(1)
Mobile application testing
(1)
Mobile Application Types
(1)
Mobile Testing
(2)
NoSQL
(1)
ORACLE
(9)
PL/SQL
(1)
Scrum
(1)
SDLC
(33)
Selenium
(6)
Selenium Common Exceptions
(1)
Selenium FAQ
(5)
Selenium FAQ's
(1)
Selenium Grid
(1)
Selenium Interview Questions
(1)
Set Career Goals
(1)
Shell Scripting
(6)
Skills Required for Software Tester
(1)
Software Testing
(43)
Sprint
(1)
SQL
(11)
STLC
(33)
T-SQL
(1)
Testing E-commerce Websites
(1)
Testing Life Cycle
(33)
Testing process
(8)
TestNG
(7)
TestNG Questions & Answers
(1)
TestNG Assertions
(1)
TestNG Scripts
(4)
VI Editor
(6)
Web Services Testing
(1)
Web Testing
(1)
WebDriver
(6)
Webdriver Questions & Answers
(1)
Webservices API Testing
(1)
Writing Good Agile User Stories
(1)
WwebDriver Scripts
(4)