Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What is unit testing & how it is done?

asked marvit September 20, 2014 08:03 AM  

What is unit testing & how it is done?


1 Answers

answered By Mswami   0  
Unit testing can be broadly classified into 2 categories.

Quantitative Testing

Validate your Source and Target

a) Ensure that your connectors are configured properly.

b) If you are using flat file make sure have enough read/write permission on the file share.

c) You need to document all the connector information.

Analyze the Load Time:

a) Execute the session and review the session statistics.

b) Check the Read and Write counters. How long it takes to perform the load.

c) Use the session and workflow logs to capture the load statistics.

d) You need to document all the load timing information.

Analyze the success rows and rejections:

a) Have customized SQL queries to check the source/targets and here we will perform the Record Count Verification.

b) Analyze the rejections and build a process to handle those rejections. This requires a clear business requirement from the business on how to handle the data rejections. Do we need to reload or reject and inform etc? Discussions are required and appropriate process must be developed.

Performance Improvements:

a) Network Performance

b) Session Performance

c) Database Performance

d) Analyze and if required define the Informatica and DB partitioning requirements.

Qualitative Testing:

Analyze & validate your transformation business rules. More of functional testing.

e) You need review field by field from source to target and ensure that the required transformation logic is applied.

f) If you are making changes to existing mappings make use of the data lineage feature Available with Informatica Power Center. This will help you to find the consequences of Altering or deleting a port from existing mapping.

g) Ensure that appropriate dimension lookupÂ’s have been used and your development is in Sync with your business requirements.

   add comment

Your answer

Join with account you already have



 Write A Tutorials
Online-Classroom Classes

  1 person following this question

  2 people following this tag

  Question tags

informatica × 1

Asked 2 years and 3 months ago ago
Number of Views -269
Number of Answers -1
Last updated
2 years and 1 month ago ago

Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!