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

Is a QA tester better than a software developer?

  Software development and software testing, are the two main paths in software science, have long clashed. When choosing one of them for their career, people frequently need clarification. This is because these career alternatives are the subject of numerous myths that conflict with one another. Graduates can find employment in various fields, including software development and testing. One needs in-depth topic knowledge and practical experience to overcome the obstacles in each work area. However, when software testing is compared to software development, people mistakenly believe it needs to be more critical. Software testers are in great demand because the career opportunities are on par with those of software developers. Let's see about does a QA tester is better than a software developer: Significance Testing is a requirement for software to be complete. Software testing examines the program to see if it adheres to industry standards, how satisfied users are with it, and if t...
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 th...
Read more