Difference between Storedprocedure notification, stored procedure with signature notification?



Difference between Storedprocedure notification, stored procedure with signature notification?..

Answer / Tanmay Singh

StoredProcedure Notification and Stored Procedure with Signature Notification are two different features used in data integration solutions. Here's a brief explanation of each:

1. StoredProcedure Notification: This feature allows you to execute SQL stored procedures on the source or target systems when an event occurs, such as the start, end, or error during an ETL (Extract, Transform, Load) process.

2. Stored Procedure with Signature Notification: This feature is an extension of the regular StoredProcedure Notification where you can pass parameters to the stored procedure and receive the results. It allows for more flexibility and customization in handling data integration events.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Middleware AllOther Interview Questions

If you take 10 transformers in a try sequence, in which order error will be executed in the sequence?

1 Answers   Cap Gemini,


What is GSS-API?

1 Answers  


What is a heap dump, thread dump?

1 Answers  


What IDL compiler options help reduce the footprint?

1 Answers  


What is mod_cluster In JBOSS and Weblogic?what is the use mod_cluster?

1 Answers  


What's the relationship between OCI's TAO and DOC's TAO?

1 Answers  


What ORBs does TAO interoperate with?

1 Answers  


How to assign the ssl certificate to particular qm?

1 Answers  


What is a heap dump?

1 Answers  


How does SESAME relate to the CORBA Security service?

1 Answers  


Are agents will going to work on the Internet ?

1 Answers  


how to know that the port 9060 is running and how to find the processes that are using 9060 in ibm websphere application server

2 Answers   IBM, Tech Mahindra,


Categories