Answer Posted / rkumar.etl
Unit testing in Informatica performed using ...
1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.
2)column to column mapping to make sure the result passing
to columns are correct.
3)data type mismatch or matched.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the issues you have faced in your project? How did you overcome those issues?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What is Index Caches size?
How to update a particular record in target with out running whole workflow?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
how we can load rejected record's at run time?(not through bad files)
Is it possible to define a single node as a Gateway node as well as worker node?
Explain sessions. Explain how batches are used to combine executions?
What is joiner change?
What is olap (on-line analytical processing?
What are the modules in Power Center
If informatica has its scheduler why using third party scheduler?
where to store informatica rejected data? How to extract the informatica rejected data?
When do you use sql override in a lookup transformation?
Which transformation is needed while using the Cobol sources as source definitions?