Unit testing into informatica
How can we do unit testing into the informatica? How to load data in the informatica?
Expert
Unit testing are of two types
i). Quantitative testing
ii). Qualitative testing
Steps
i). First authenticate the mapping
ii). Make session on mapping and then run the workflow.
Once the session is succeeded the right clicks on the session and go for statistics tab. There you can see how many number of the source rows is applied and how many number of the rows loaded into the targets and how many number of the rows are rejected. This is known as Quantitative testing.
If once rows are effectively loaded then we will go for the qualitative testing.
1. Take the DATM (DATM defines where all business rules is mentioned to corresponding source columns) and check whether the data is loaded according to DATM into target table. If any data is not loaded according to DATM then go and verify in code and rectify it. This is known as Qualitative testing.
Illustrates the recursive stored procedures?
What is meant by the Cardinality?What is meant by the Cardinality?
Illustrate the five SQL built-in functions.
Describe briefly the term ODBC?
States the term second normal form?
Explain the terms SQL Server and adaptive server enterprise?
Describe briefly the difference between identifier and attributes?
Describe the process that takes place to execute a stored routine.
Specify the designer tools used for creating the tranformations?
Give brief introduction of the term ‘Service Broker components’?
18,76,764
1925505 Asked
3,689
Active Tutors
1415347
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!