ETL TESTING BY H2KINFOSYS

ETL testing is a process done to ensure that the data is properly loaded from source to destination after the business is transformed accurately. ETL testing involves the verification of data at various middle stages that are being used between source and destination.

What is Data Warehouse?

Data warehouse is a huge collection of information from different sources. This information can be used for decision making and planning. It is a kind of database which is designed for querying, analysis and transaction processing. It helps the company or any organisation to consolidate data from several sources and separates analysis workload from transaction workload. Data is turned in to high quality information to meet the enterprise documenting requirements for all levels of users.

What is ETL?

It is the process of how data is loaded from different sources to data warehouse. It stands for Extract-Transform-Load. Data is extracted from the OLTP database and transformed to match the data warehouse schema and it is been loaded into the data warehouse database. For Example if there is a company it has many departments like Sales, Marketing and HR department. Each department have maintained the data of Employee separately. Some departments will store employee information by the employee’s name and some of the departments will store employee’s information by employee-Id. If they want to check the employee’s history then it will be tedious job. The solution is to use the data warehouse to store information from different sources in a uniform structure by ETL. ETL can transform dissimilar data into uniform structure.

ETL Testing Process

The different ETL testing phases are
ETL TESTING
ETL TESTING


ETL Testing performed in 5 stages:
  1. Identifying data sources and requirements
  2. Data acquisition
  3. Implement business logics
  4. Build and populate data
  5. Build reports
Types of ETL testing:
  1. Production validating testing: This type of testing is done to data as it is moving  to production systems. To support  your  business decision, the data in the production systems should be in the correct order. Data validation option ETL testing automation and management capabilities to confirm that the production systems  does not compromised by the data.
  2. Metadata Testing: It includes testing of data type, data length, constraint of data.
  3. Data completeness testing: data completeness testing is done to assure that the data is loaded in target from the source. Some tests that run are compare and validate counts.
  4. Data Accuracy testing: This testing is done to ensure that the data is  accurately loaded  and transformed as expected.
  5. Data Transformation testing: It verifies the data is correctly transformed according to the business availabilities.
Questions
  1. What is ETL Testing?
  2. What are advantages of ETL Testing?
  3. What are the types of ETL Testing?

Comments

Post a Comment

Popular posts from this blog

5 Steps to Becoming a Certified Business Analyst

Image
  Business analysts are among the most in-demand professionals today, and demand for them is only going up. So how can you demonstrate to potential employers that you have the skills necessary to complete this task? Getting one of the various business analysis credentials by holding a business analyst certification would be the answer for it. If you have a business analyst certification after completing an   online business analyst course , your resume will have the qualifications the employers are looking for. The certification you have will prove that you finished and passed the test that evaluates your abilities.  Your qualifications can make you stand out among other job participants. You can get the benefit of more salary, career prospects, and greater job stability. If you have interest in becoming a certified business analyst, here are the five steps you should take: What is a business analyst certification? Business analysts use the information they gather from an organization&
Read more

How to perform gap analysis as a Business Analyst

  A firm compares its present performance to its performance objectives or goals through a gap analysis. Its purpose is to assist companies in locating any weaknesses or holes they may have so that a plan can be developed to address them and enhance corporate operations. Even if it might appear complicated initially, a gap analysis can be finished in the simple steps indicated in the free gap analysis template. But anyone can complete the procedure with training and a well-made gap analysis template. Here mentioned are the steps to perform gap analysis as a business analyst: What can a gap analyst do? A gap analysis compares actual results to anticipated ones to pinpoint ineffective or absent strategies, processes, technology, or abilities. Utilize the gap analysis findings to suggest steps your business should take to achieve its objectives. Companies, business units, or teams can identify what they need to focus on to improve performance or results and move more quickly toward the de
Read more

Will qa engineers get replaced?

  An individual who employs software quality assurance concepts and methods throughout the life cycle of software development is known as a quality assurance analyst. Software quality assurance covers the entire software development life cycle, including software design, requirements management, testing, coding, and release management. Software testing is designed, planned, and carried out with quality assurance analysts. The development team, business analyst, and quality assurance analyst collaborate closely to approve test cases based on software requirements. The person who tries to break software most often is a QA analyst. Every time the program fails, the QA analyst feels some sense of achievement because it helps to prevent the flaws from making it to the production stage. Below listed are the future scopes of QA engineers: How it works: The same test suite must be run repeatedly over the product development cycle. You should attend  software testing training online   to become
Read more