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 |
If you take 10 transformers in a try sequence, in which order error will be executed in the sequence?
What is GSS-API?
What is a heap dump, thread dump?
What IDL compiler options help reduce the footprint?
What is mod_cluster In JBOSS and Weblogic?what is the use mod_cluster?
What's the relationship between OCI's TAO and DOC's TAO?
What ORBs does TAO interoperate with?
How to assign the ssl certificate to particular qm?
What is a heap dump?
How does SESAME relate to the CORBA Security service?
Are agents will going to work on the Internet ?
how to know that the port 9060 is running and how to find the processes that are using 9060 in ibm websphere application server