Skip to main content
4 votes

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?

I would split your question into two parts: What needs to be tested? You have already covered some critical scenarios. Besides these following should also be covered-: -Ensure that all ...
SiriA's user avatar
  • 61
3 votes

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?

How complicated is the ETL logic? Are you bringing over every record? Do you transform the data? I would create targeted test data to test the logic itself. Once you know what you know exactly which ...
David Cain's user avatar
3 votes

How far would you go in ETL and data warehouse testing?

As a general principle, testing is about risk/reward, which comes down to cost in terms of money/time/resources (people/machines) in various combinations. The test coverage curve will be some sort of ...
Marcus D's user avatar
  • 320
1 vote

Big data application testing

This will depend on a number of factors, including: time/budget, data quality policy of your organization, data quality of the source dataset, complexity of each layer, etc. A general guideline is, ...
Maira Bay's user avatar
  • 194
1 vote

aws data pipeline testing tools

Let me revive this topic so others can contribute and I'll share few cents of my recent experience. Firstly I think the important bit is to TEST the application under test - could be an API, a process ...
user2573747's user avatar
1 vote

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?

The best way to ensure the completeness and correctness of data is by testing it in SQL. Can you try creating a database on your machine and use import\export wizard in SQL server and import the ...
Aalok's user avatar
  • 1,732
1 vote

Any advice on testing sprocs that feed into an API?

I'd say it depends on what sort of testing you're doing, and how much testing of the sprocs will have been done by the time they get to you. If you think of the system in terms of a program, testing ...
Kevin McKenzie's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible