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 |
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
In session log thier should not be a single error how will u do
how can you load data into target table without leading zeor's
Define Pmrep command?
what is the flat file partition and where have to specify it
What is the need of etl tools?
What are the Advantages of de normalized data?
How do you manage the Parameter files while migrating your data from one environment to another environment?
what is song in infrmatica...?
What are the differences between joiner transformation and source qualifier transformation?
What are the session parameters?
What is the meaning of up gradation of repository?