19.SQL Transformation in Informatica Cloud 2024|Stored Procedure Connected|Unconnected |SQL Query

Описание: Welcome to our YouTube channel where we delve into the world of data integration using Informatica Intelligent Cloud Services (IICS). Discover the power of Informatica Cloud! Dive into our video series for tutorials, tips, and insights on harnessing the full potential of Informatica Cloud for seamless data integration and management.

Don't forget to like, share, and subscribe for the latest updates and new releases!"

#informaticaiics #informaticaiicstutorial #informaticaiicsforbeginners #informaticaiicsinterviewquestionsandanswers #informaticaiicstraining #informaticaiicsinstallation #informaticaiicstutorialforbeginners #informaticaiicsarchitecture #informaticaiicsoverview #informaticaiicsrestapi #informaticaiicsapplicationintegration #informaticaiicsvspowercenter #informaticaiicsfullcourse #informaticaiicsforbeginnerstelugu #informaticaiicsinterview #informaticaiicsand #informaticaiicsdataintegration #informaticaiicsjobs
#informaticaiics
The sql transformation can call a stored procedure or function, process a saved query that you create in the transformation SQL editor.
The SQL transformation can be used both as a connected and unconnected transformation.
Stored procedure-
Stored Procedures are created to perform one or more DML operations on the Database.
It is nothing but a group of SQL statements that accepts some input in the form of parameters, performs some task, and
may or may not return a value.
Stored function –
It is same as stored procedure A stored function is a set of SQL statements that perform some operation and return a single value.
Saved or user-entered query
You can configure the SQL transformation to process a saved query that you create in Data Integration or you can enter a query in the SQL editor.
The SQL transformation processes the query and returns rows and database errors.