Stored Procedure: A Stored Procedure transformation is an important tool for populating and
maintaining databases. Database administrators create stored procedures to
automate tasks that are too complicated for standard SQL statements.
A stored procedure is a pre-compiled collection of Transact-SQL, PL-SQL or other database procedural statements and optional flow control statements, similar to an executable script. Stored procedures are stored and run within the database. You can run a stored procedure with the EXECUTE SQL statement in a database client tool, just as you can run SQL statements. Unlike standard SQL, however, stored procedures allow user-defined variables, conditional statements, and other powerful programming features.
The stored procedure must exist in the database before creating a Stored Procedure transformation, and the stored procedure can exist in a source, target, or any database with a valid connection to the Integration Service.
A stored procedure is a pre-compiled collection of Transact-SQL, PL-SQL or other database procedural statements and optional flow control statements, similar to an executable script. Stored procedures are stored and run within the database. You can run a stored procedure with the EXECUTE SQL statement in a database client tool, just as you can run SQL statements. Unlike standard SQL, however, stored procedures allow user-defined variables, conditional statements, and other powerful programming features.
The stored procedure must exist in the database before creating a Stored Procedure transformation, and the stored procedure can exist in a source, target, or any database with a valid connection to the Integration Service.
Thank you for providing useful content Informatica Online Course Hyderabad
ReplyDeleteI think that is actually a very nice and smart explanation about Informatica installation and its other useful aspects.
ReplyDeleteInformatica Read Soap API