Timeline for I have an ETL scenario where my source is Database and Target is flat file. How best can I test it to make bug free?
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 19, 2017 at 0:49 | comment | added | David Cain | Make your own database. Insert the data you need for your tests. | |
| Jan 11, 2017 at 14:16 | comment | added | A Ahmed | Thanks for responding. I can say ETL logic is of medium complexity. The o/p flat file has 100+ fields sourced from 10+ tables. Each record is valid and runs upto millions. Pivot logic is also used to enable fetching of row-wise lookup data into single record. On the source side as a tester I have read only access. If I need to simulate same source test data in the my local database then I am not sure if I can replicate whole data/business scenarios. | |
| Jan 5, 2017 at 21:07 | history | answered | David Cain | CC BY-SA 3.0 |