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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is domain in terms of informatica?

558


explain about unit testing? in real time?

1651


can we override a native sql query within informatica? Where do we do it? How do we do it?

595


Mention few power centre client applications with their basic purpose?

528


What are the components of workflow manager?

583






What is sequence generator transformation in informatica?

616


Can anyone tell me the new features in Informatica 9 Version?

1524


What are junk dimensions?

626


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1651


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6059


What is session task and command task?

643


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

7666


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

627


How to implement security measures using repository manager?

598


How is union transformation utilized?

562