ETL Testing and Informatica Training

Based on the interest and request from all the students and learners we are going to start online classes and offline/classroom classes for ETL Testing and Informatica Training

ETL Testing and Informatica Training
@ Real Time with good success rate call +91-8237320101 and +91-9885320101


Online Trainings
-All working days and weekends


Pune
- Monday to Friday
                                         -  Vishrantwadi, Pune,Maharashtra - 411 015

Pune
- Weekends
                                         -  Hinjewadi, Pune,Maharashtra - 411 057

Bangalore

- Weekends
                                         -  Kasturi Nagar,Nr Tin Factory,Bangalore - 43

Hyderabad
- Weekends
                                         -  Ameerpet,Hyderabad

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 

Data Completeness Test

1.Data completeness test are designed to verify that all the expected data loads into the DWH.

2.It includes running detailed tests to verify that all records,all fields and full contents of each field are loaded correctly or not.

3.Strategies to consider includes:

a)Record counts must compared between source and the target data.

b)Comparing record counts between source and data loaded to the warehouse (Target) and also rejected records in warehouse (Target).

c)Comparing unique values of key fields between source data and data loaded to the warehouse (Target) column mapping from the source or stage.

4.Populating the full contents of each field to validate that have no truncation occurs at any step in the process for example if the source data fields is having string(30) and make sure that to test it with 30 characters.