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 |
Discuss the advantages & Disadvantages of star & snowflake schema?
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
why we use stored procedure transformation?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
Is it possible to use a client with different version than that of its Informatica server?
what is mapping parameter and mapping variables
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
wf dont have integration severances how you can run?
What is native users?
Why update strategy and union transformations are active?
can we use self join in informaitca?