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 |
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
what is session parameters?
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain direct and indirect flat file loading (source file type) - informatica
What is the meaning of up gradation of repository?
Suppose we do not group by on any ports of the aggregator what will be the output?
What are the types of data that passes between informatica server and stored procedure?
how can one come to know wether the records loak into the target if we use update strategy
How to extract sap data using informatica?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation