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
- 11831 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 |
Explain the different dimensions.
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
list out all the transformations which use cache?
How does a rank transform differ from aggregator transform functions max and min?
What is a mapplet/worklet in informatica?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
Is it possible to revert a global repository to local one and why?
What is an expression transformation?
What is incremental aggregation?
Teradata 
