What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 13942 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / manjunath
Stored procedure transformation is used to invoke the database procedure or function stored in the database. it needs the connection to the database. Where as the external procedure transformation is used to invoke the application function developed either in C/C++/VB.The external procedure needs to be bind with the external procedure transformation in the designer so the the application function would be loaded at the run time like a DDL.
| Is This Answer Correct ? | 0 Yes | 1 No |
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
What are the different lookup cache(s)?
What is session task and command task?
what is mystery dimension?
What are reusable transformations in how many ways we can create them?
What are set operators in Oracle
What is the Difference between SetVariable and setmaxvariable in informatica?
WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...
What are Rapid changing dimensions?
Teradata 
