Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between stored procedure transformation
and external procedure transformation?
- 2 Answers
- 14442 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
In informatica workflow manager, how many repositories can be created?
What are the tasks that source qualifier perform?
Explain the shared cache and re-cache?
What is informatica? Why do we need it?
CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks
without table how to come first record only in oracle?
What is the difference between a connected look up and unconnected lookup?
Explain how many types of dimensions are available in informatica?
What is the need of etl tools?
How do you load first and last records into target table?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is informatica etl tool?
How can we remove the duplicates from flat file source?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the databases that informatica can connect to windows?
