Why are we doing ETL process: Customers are increasingly focusing on the collection and organization of data for strategic decision-making. The ability to review historical trends and monitor near real-time operational data has become a key competitive advantage. General goals of testing an ETL application: * Data completeness: Ensures that all expected data is loaded. * Data transformation: Ensures that all data is transformed correctly according to business rules and/or design specifications. * Data quality: Ensures that the ETL application correctly rejects, substitutes default values, corrects or ignores and reports invalid data. * Performance and scalability: Ensures that data loads and queries perform within expected time frames and that the technical architecture is scalable. * Integration testing: Ensures that the ETL process functions well with other upstream and downstream processes. * User-acceptance testing: Ensures the solution meets users' current expec...
Comments
Post a Comment