Why we use stored procedure transformation?
Answers were Sorted based on User's Feedback
Answer / anilchandu
Instead of writing complex logics in expression t/r we will
use Stored procedure t/r.
The main advantage of stored procedure t/r is the code
reusability.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / rajbir
We use stored procedure transformation top evalate the
expression for rows at database level so that we can use it
again n again according to our requirment
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we use mapping variables in informatica? Where do we use them?
How do you Merge multiple Flat files for example 100 flat files with out using Union T/F
How can we store previous session logs?
Explain lookup transformation in informatica
which transformation uses cache?
If we are using an aggregator but forget to mention the group by port .what will be the output??
What is partioning?how many types of partinings are there
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
can anyone explain me about retail domain project in informatica?
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,