Active5 years, 6 months ago
Unit Testing Template For Etl Testing. 5/18/2017 0 Comments Dynamic Testing; Testing done without executing the program: Testing done by executing the program: This testing does verification process. ETL testing or data warehouse testing is one of the much in demand testing skills. This article will present you with a complete idea about. Intertek's ETL Mark was born into a culture of innovation. It was in Thomas Edison's lighting laboratories where it all began, and to this day we still breathe the same air of innovation, safety and quality. Check out our white paper The Essential Guide to Product Testing & Certification.
Can I unit test Informatica Powercentre workflows?
Product Safety Testing and Certification Services Supplier INTERTEK TESTING SERVICES TAIWAN LTD. Discount Price Price Request for Quotation. Insert a template. Etl/qa/ Bi Tester Resume. Created Test Case documents in MS Excel template from the Test Plan and the Business Requirements documents. High Level Designing and Detail Technical Design of ETL application. Involved in unit testing and integration testing of the developed work Analyzed production support issues. Intertek ETL SEMKO Korea Ltd. - The unit shall be installed in compliance with the mounting, spacing, segregation and enclosure requirements of the ultimate application. This document is the property of Intertek Testing Services and is not transferable. The certification mark(s) may be applied only at the location of the Party Authorized.
EDIT:More specifically, can I mock sources and target and test the steps in between? Eg. If I have a workflow with a Oracle source and a text file target can I test it without Oracle and a text file.?
Tommi7,26555 gold badges2828 silver badges5151 bronze badges
![Login Login](/uploads/1/2/6/0/126085621/272264030.jpg)
35722 gold badges1111 silver badges2424 bronze badges
3 Answers
No you can't.
When you create and save a mapping Informatica validates if the mapping is syntactically valid. It will give you an error message if it's not. Look for the errors in the bottom panel. You can validate a mapping by going to Mappings Menu > Validate.
You can validate a workflow similarly : Workflows Menu > Validate.
To run the workflow it is necessary that you have the source and target available and connected. If you don't want to write to target or don't want to do full volume testing you can use 'Enable Test Load' at the Session level (Edit > Properties > Enable Test Load) and set 'Number of rows to test'.
RuchiRuchi
Yes, you can run the work flow and test the output target table.(From the work flow manager, right click on a work flow, and click 'run work flow from start'.
Once the work flow is successful, view the data in the target to see of the mappings and transformations are working fine.
Just like any other Unit testing, you'll need to identify the records in your source (and target) and the expected results in the target before you run your work flow.
Eg If I want to test a mapping which has the SCD type2 logic, you can run the work flow twice and update the source columns as needed and after running the work flow, check if the current record has been updated correctly and if the new row for a history version of the record has been updated correctly.
Rajesh ChamarthiIntertek Etl Logo
Rajesh Chamarthi16.6k11 gold badge2727 silver badges5959 bronze badges
What we're trying to do in Informatica is build a source file, build an expected output file and then run a workflow to produce an actual output file. We then do a bytecode comparison of our expected output file versus our actual output file. What we're actually testing for here is whether or not our mapping logic is implemented as we believe it should be implemented.
The following python script will do the testing:
Intertek Testing Services
Not exactly mocking, but essentially will be what's necessary to correctly test that your mapping is correct. Validity of the mapping is checked my Informatica itself.
Anish PatelAnish PatelIntertek Etl Listed Products
38522 gold badges55 silver badges1717 bronze badges