What are the things you would consider for ETL automation framework?
Consider there are webservices or microservices between data integration layer and Oracle database. How would you test with ETL and ensure data before transmission is stored without losing integrity?
How do you handle more than 500 rows?
How do you perform record to record comparison?
Please add your analysis in an excel sheet
Sample Solution