QA Opening
Hi guest,

Please register on this forum to get access to all features of this forum.

If you are already a registered user of this forum, log into your account.


Thank You !

Join the forum, it's quick and easy

QA Opening
Hi guest,

Please register on this forum to get access to all features of this forum.

If you are already a registered user of this forum, log into your account.


Thank You !
QA Opening
Would you like to react to this message? Create an account in a few clicks or log in to continue.
Latest topics
» Job | Looking for QA Engineers (Selenium), for TO THE NEW Digital, Noida
Database testing EmptyMon Nov 23, 2015 11:52 pm by ruchika jagotta

» Database testing
Database testing EmptyFri Sep 11, 2015 5:32 pm by QA-Opening

» Credit card payment steps
Database testing EmptyFri Sep 11, 2015 3:58 pm by QA-Opening

» Job | Urgent Position: Automation/manual Testing: CMM Level 5 Client
Database testing EmptyFri Sep 11, 2015 12:53 am by QA-Opening

» Job | Opportunity with an Product Based Company @ Noida
Database testing EmptyFri Sep 11, 2015 12:52 am by QA-Opening

» Job | Urgent Requirent---Automation Test Engineer
Database testing EmptyFri Sep 11, 2015 12:52 am by QA-Opening

» Job | Job opening for Automation testing @ Capgemini Bangalore
Database testing EmptyFri Sep 11, 2015 12:50 am by QA-Opening

» Job | Manual Testing openings at Cigniti for immediate joiners - Delphi
Database testing EmptyFri Sep 11, 2015 12:49 am by QA-Opening

» Job | Contract to Hire Openings for Automation @ Mangalore
Database testing EmptyFri Sep 11, 2015 12:48 am by QA-Opening

Poll
Search
 
 

Display results as :
 


Rechercher Advanced Search

March 2024
MonTueWedThuFriSatSun
    123
45678910
11121314151617
18192021222324
25262728293031

Calendar Calendar

Keywords

2015  link  

Who is online?
In total there is 1 user online :: 0 Registered, 0 Hidden and 1 Guest

None

Most users ever online was 78 on Fri Sep 10, 2021 3:20 am

Database testing

Go down

Database testing Empty Database testing

Post by QA-Opening Fri Sep 11, 2015 5:32 pm

Database Test Scenarios:

1. Structure Validation
a. Validate the source and target table structure as per given requirements.
b. Verify that data field types and formats are specified
c. Source data type length should not less than the target data type length.
d. Validate the name of columns in target table as per given requirements.

2. Constraint Validation
a. Primary Key Constraint should be enabled on Target Table.
b. Foreign Key Constraint validation if specified in the Target Table.
c. Not Null Constraint Validation on specified Fields as per given requirements.
d. Unique Constraint Validation on specified Fields as per given requirements.

3. Data Completeness Validation
a. Validation of rows count in Source and Target table on Each ETL Run.
b. Validation of any truncated data in any columns in target table.
c. Validation of boundary value analysis For Ex : If we load Data in Target table for Date>=2014-01-01 then No Data prior to this data should
Load in target table.
d. Validation of Source and Target data on basis of any unique key present in Source table.
e. Validation of Data at boundary by comparing first and last row of Source and Target Tables

4. Data Correctness Validation
a. Validation of any misspelled on inaccurate data in target table.
b. Validate null, non-unique or out of range data stored in target table when no constraints arespecified.
c. Validation of Column Data in Tables as they are containing values as per given data types and formats specified

5. Data Quality Validation
a. Numeric Fields Validation whether they are containing values as per given requirements.
b. Date Format validation of Fields that is containing Date Values.
c. Precision check validation of Decimal values.
d. Validation of data as per given requirements means few records does not meet certain criteria should be filtered out
e. Validation of Negative values in Numeric Fields .

6. Duplicate Check Validation
a. Validate Primary key, unique key column for duplicate values.
b. Validation of Duplicate values exists in any column which is extracting from multiple columns in source and combining into one column in source.

QA-Opening
Admin

Posts : 79
Join date : 2015-09-03
Age : 34
Location : Noida

https://qa-openings.editboard.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum