Data Transformation Test

Data transformation test:

1.It’s a process of converting,cleansing,scrubbing,merging the data into required business format.

2.Validating that the data is transformed correctly or not,based on the business rules/business requirements,

Business rules/requirements validating can be the most complex and important part of ETL testing. 

3.An ETL application(i.e.Informatica,Datastage..etc) with significant transformation logic between source and target,where test should be make sure that the datatype of each column of each table is as per the functional and mapping specifications,If no specific details are mentioned in functional and mapping specifications about the tables/schema's then test should be make sure on the below concerns:

a)The datatype of source column and destination column(Target column) are same or not.

b)The destination column length is equal to or greater than the source column length.

c)Validation should be done that all the data specified gets extracted.

d)Test should include the check to see that the transformation and cleansing process are working correctly.

e)Make sure that all the types of data transformations are working and meeting the FS/MS and Business requirements/rules.

The following types of data transformation makes place in staging

1. Data Cleansing 

2. Data Scrubbing  

3. Data Aggregation  

4. Data Merging