Interested to Buy Any Domain ? << Click Here >> for more details...
Hi all, iam new to informatica, can anyone tell me
what is unit testing & how it is done?
thank u
- 3 Answers
- 12050 Views
- I also Faced
- E-Mail Answers
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 |
What is a design?
can u give example for factless fact table
What are ETL Tools?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
r u done any partitions in ur project?
What do you understand by a term domain?
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
Can we insert and update a target table without using update strategy transformation?How?
What is the difference between stop and abort in informatica
how eliminate the duplicates in flat file with out using sorter ,aggregater
Is it possible to update the target table with PK?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Teradata 
