What is difference between stored procedure transformation
and external procedure transformation?
Answer Posted / swetha
In case of storedprocedure transformation procedure will be
compiled and executed in a relational data source.yoU need
data base connection to import the stored procedure in to
your maping.Where as in external procedure transformation
procedure or function will be executed out side of data
source.Ie you need to make it as a DLL to access in your
maping.No need to have data base connection in case of
external procedure transformation.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is standalone command task?
Briefly describe lookup transformation?
design of staging area?
What do you mean by channel change?
Define sessions in informatica etl?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
explain about unit testing? in real time?
What is session task and command task?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What are the differences between oltp and olap?
What are the differences between a connected lookup and unconnected lookup?
How many number of sessions can one group in batches?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain load alternative records / rows into multiple targets - informatica
How an expression transformation differs from aggregator transformation?