what ETL is and the challenges posed by it,how would you address the challenges?

label Computer Science
account_circle Unassigned
schedule 1 Day
account_balance_wallet $5

Explain what ETL is and the challenges posed by it and how would you address these challenges?

May 3rd, 2015

ETL refers to  extract, transform and load. It is a concept in relation to data warehousing. 

  - Extract data from data sources

-Transforms the data so that it can be stores in proper format or structure. This way data becomes usable for analysis purposes

- Load the data into final target i.e. to give it as input for analysis


Most of the current test automation tools are focused on transaction application testing and are not designed for testing of data warehouses. Hence it is a common practice to test the ETL by copying a handful of records from source and target tables into an excel spread sheet and compare the data. This is a tedious and error prone process when done manually for large number of ETL. Testing is further complicated because the ETL process can run in an incremental mode or full mode often making it necessary to create separate sets of test cases for these two modes. Every incremental change to the source or target system increases the scope errors and redundancy in the data. 

Thus major challenges are - 

      - Incompatible and duplicate data.

      - Loss of data during ETL process

      - Volume and complexity of data is very huge

    Possible solutions
  • Validating - Validating the correctness of the data at each level. Though it might slows down the process but it increases the accuracy level.
  • Test planning based on the inputs from test estimation and business requirement
  • Designing test cases and test scenarios from all the available inputs
  • Once all the test cases are ready and are approved, testing team proceed to perform pre-execution check and test data preparation for testing

May 3rd, 2015

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
May 3rd, 2015
May 3rd, 2015
Jun 22nd, 2017
Mark as Final Answer
Unmark as Final Answer
Final Answer

Secure Information

Content will be erased after question is completed.

Final Answer