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



Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? tha..

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

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? tha..

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

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? tha..

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

Post New Answer

More Informatica Interview Questions

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,


In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  


How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

2 Answers   CTS,


Explain how to import oracle sequence into informatica?

0 Answers  






Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,


I still need further explanation about the difference between active and passive transformation with some examples.Thank You

5 Answers  


What are session parameters ? How do you set them?

0 Answers  


how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,


how many session run unix environment what command using ?

1 Answers   HCL,


hi all, Can anyone please tell me the relationship between informatica and business objects

1 Answers  


what we require for D.modelling?

1 Answers  


Categories