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
Under what condition selecting sorted input in aggregator may fail the session?
What is intricate mapping?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is a sorter transformation?
How can we delete duplicate rows from flat files?
What is incremental aggregation?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What the difference is between a database, a data warehouse and a data mart?
What is powercenter on grid?
What is session task and command task?
what are the Methods For Creating Reusable Transformations?
COM components can be used in Informatica
Differentiate between a database and data warehouse?