Hi all, iam new to informatica, can anyone tell me
what is unit testing & how it is done?
thank u
Answers were Sorted based on User's Feedback
Answer / gaurav
Unit testing is a process where u would be testing ur
application or mapping by taking sample data to check if it
satisfies the business rules.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sri ram
You can do unit testing by testing your mapping
1.develop the mapping,take target as a .csv file(if the
target db location is remote)
2.give some input satisfying business rules
3. check whether the output is generated appropriately
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shaik
Unit Testing is one of the testing process to provide some
sample data (hard coded data some times) to ensure your
logic is working as expected.
Talking Unit Testing specific to Informatica this is how I
did :
1. Generate a reference table from a .csv file on
Informatica Analyst.
2. Generate a profile using this Reference table( when ever
a reference table is creared a corresponding sql table is
created in the provided db during configuration)
3. Apply your rule (mapplet) on your profile and check if
you get the expected results.
4.You can add /remove data in the reference table to check
various scenarios.
| Is This Answer Correct ? | 2 Yes | 1 No |
Is there any way to read the ms excel datas directly into informatica?
what are the real time problems generally come up while doing or running mapping or any transformation?
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
what are the types of Data warehousing ?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
What is an unconnected transformation?
How can you run a session without using server manager?
What is Data Caches size?
what is target update override and when we use it?
How can we improve session performance in aggregator transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is a grid in Informatica?