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 Active lock explain
What are the differences between source qualifier and joiner transformation?
Write the unconnected lookup syntax and how to return more than one column.
Design time, run time. If you don't create parameter what will happen
What is the format of informatica objects in a repository?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Informatica Checkpoints
if we have a delimiters at unwanted places in a flat file how can we over come those.
In how many ways we can create ports?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Differentiate between Load Manager and DTM?
What are the features of complex mapping?
design of staging area?
Enterprise data warehouse your projects phase by phase explain?
what are the deliverables?in your project?