Can any body tell about the (UTC) unit
test cases with the examples in informatica.

Answers were Sorted based on User's Feedback



Can any body tell about the (UTC) unit test cases with the examples in informatica. ..

Answer / shankar nm

Step 1. Have your valid mapping ready.
Step 2. Go to Debugger mode, set your breakpoints
Step 3. Activate view of target, output, input to ON
Step 4. choose View -> navigate to debugger, turn instance
data and target data ON by checking
Step 5. Use Func.Key or use mouse to go to next instance
check the output on target. follow the flow.

Alternate way is to check the SQL on TOAD to check the
number of rows meeting the criterion in each component.

Is This Answer Correct ?    5 Yes 0 No

Can any body tell about the (UTC) unit test cases with the examples in informatica. ..

Answer / praveen kumar pendekanti

Take 10 rows (use rownum<11 in session sql override) copy
that 10 rows and paste in excel sheet then run the session
there by we will get output as 10 rows then check that we r
getting 10 rows same as source and also check the business
logic and date conversions(carefully) if all these r
getting correctly there by capy that 10 rows from the
target table and paste that rows in excel sheet....
Dont forget to take paste the sql override query in excel
sheet and finally take the session log of that session and
add that one in excel sheet.......

very important don't override in mapping source qualifer ok


if i am wrong let me know

Is This Answer Correct ?    3 Yes 0 No

Can any body tell about the (UTC) unit test cases with the examples in informatica. ..

Answer / shashiall

prveen ..then where will we do SQL override?

Is This Answer Correct ?    1 Yes 0 No

Can any body tell about the (UTC) unit test cases with the examples in informatica. ..

Answer / dilip

I want to more to whatever is above, for the unit test
cases try to validate your all the transformation rule e.g
to_date,null check, look up cases and the stubbing cases if
any in the mapping.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is data driven?

1 Answers  


normalizer transformation

3 Answers   CTS,


what are the difference between Informatica 7.1 and 8.1?

6 Answers  


Hi, Can someone send me the DWH and Informatica FAQ's at vanibv6@gmail.com Thanks in Advance, Vani

2 Answers   Wipro,


what is degenerated dimension table with scenario

2 Answers   HCL,






Explain what are the different versions of informatica?

0 Answers  


how u know when to use a static cache and dynamic cache in lookup transformation.

9 Answers   Accenture,


Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  


The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  


What are the informatica performance improvement tips

0 Answers   Informatica,


What is different between the data warehouse and data mart?

0 Answers  


Categories