Results 1 to 8 of 8

Thread: ETL Testing

  1. #1
    Junior Member
    Join Date
    Nov 2009
    Answers
    10

    ETL Testing

    What is ETL Testing?For which type of application this is used and what r the process which should be followed during ETL Testing.
    thanx


  2. #2
    Expert Member
    Join Date
    Oct 2007
    Answers
    375

    Re: ETL Testing

    Hi,

    ETL basically stands for Extract Transform Load - which simply implies the process where you extract data from Source Tables, transform them in to the desired format based on certain rules and finally load them onto Target tables. There are numerous tools that help you with ETL process - Informatica, Control-M being a few notable ones.

    So ETL Testing implies - Testing this entire process using a tool or at table level with the help of test cases and Rules Mapping document.

    In ETL Testing, the following are prima facie validated -
    1) Data File loads from Source system on to Source Tables.
    2) The ETL Job that is designed to extract data from Source tables and then move them to staging tables. (Transform process)
    3) Data validation within the Staging tables to check all Mapping Rules / Transformation Rules are followed.
    4) Data Validation within Target tables to ensure data is present in required format and there is no data loss from Source to Target tables.

    What I have mentioned here is just a tip of the ice-berg and a description of ETL Testing from a very high level but hope this gives an insight about ETL Testing.

    Cheers,


  3. #3
    Junior Member
    Join Date
    Nov 2009
    Answers
    10

    Re: ETL Testing

    Thanku for ur valuable information and time.


  4. #4
    Junior Member
    Join Date
    Jan 2011
    Answers
    1

    Re: ETL Testing

    Thank u buddy


  5. #5
    Junior Member
    Join Date
    Nov 2013
    Answers
    1

    Re: ETL Testing

    This is nice article for who is interested in learning ETL testing.Thanks for sharing ETL testing Online Training information
    with us.


  6. #6

    Re: ETL Testing

    ETL testing is done by SQL scripting. These approaches to ETL testing are very time-consuming, error-prone, and seldom provide complete test coverage.ETL tool work as integrator which extracts data from different sources and transform it to preferred location ,a and format.


  7. #7
    Banned
    Join Date
    Mar 2016
    Answers
    17

    Re: ETL Testing

    Here is an answer to your query. Please check this link - bit.ly/1nVILeD


  8. #8
    Junior Member
    Join Date
    Mar 2016
    Answers
    11

    Re: ETL Testing

    ETL Testing Techniques:

    1) Verify that data is transformed correctly according to various business requirements and rules.
    2) Make sure that all projected data is loaded into the data warehouse without any data loss and truncation.


  9.  Sponsored Ads
    Ad


     

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact