What is ETL?
The process of extracting the data from different source(operational databases) systems, integrating the data and transforming the data into a homogeneous format and loading into the target warehouse database is called ETL(Extraction, Transformation, and Loading) and some times also called as Data Acquisition Process.
ETL Testing Common scenarios:
1)Verify all the DB Objects are in place as defined in the mapping document. ( Source, Staging /ODS, DWH)
2)Verify all the ETL objects are deployed to QA Environment and are valid.
3)Verify table structures of DB are the same as in the document.
4)All the flat files that are required for QA to run test are in place and is in the required format.
5)Verify that data consolidation of duplicate, truncations or merged data was properly handled.
6)Verify that data field types, formats, field precision, and field length are as specified (especially if it supports south Asian languages)
7)Verify that default values, Nulls records, Error records, Invalid data row, and status type row are properly handled.
While you have been searching for ETL Testing Training in Pune from the best AWS Training Institute in Pune, there are loads of names, which you are likely to come across But among all of them “TECHNOGEEKS” is here to help you to start within Pune location in India.
