Read previous post: Informatica interview questions and answers-1 11. Can we use the mapping parameters or variables created in one mapping into another mapping? NO. We can use the …
What is the difference between normal load and Bulk load in session properties? Bulk loading improves the performance of a session that inserts a large amount of data to …
There is a small difference between RANK() and DENSE_RANK() analytic functions. Lets take an example to illustrate this. 1. select ename,deptno,sal,RANK() OVER (PARTITION BY deptno ORDER BY SAL) from …
Choosing Proper Stages The parallel Transformer stage always generates “C” language code which will compile to a parallel component. Because of this, it is mandatory to minimize the number …
Connected Lookup Unconnected Lookup Receives input values directly from the pipeline. Receives input values from the result of a :LKP expression in another transformation You can use a dynamic …
