Unconnected Stored Procedure Transformation Example - Informatica
This is continuation to my previous post on connected stored procedure transformation example . Here I am going to use the same stored proc...
Showing posts with the label Informatica Transformations
Stored Procedure Transformation Example In Informatica
Vijay Bhaskar
In this article, we will see how to create a connected stored procedure transformation using a simple example. Example : Lets consider th...
Stored Procedure Transformation in Informatica
Vijay Bhaskar
Stored Procedure Transformation is a passive transformation. Stored procedure transformation can be used in both connected and unconnected ...
Lookup Transformation in Informatica
Vijay Bhaskar
Lookup transformation is used to look up data in a flat file, relational table, view or synonym. Lookup is a passive/active transformation ...
Update Strategy Transformation in Informatica
Vijay Bhaskar
Update strategy transformation is an active and connected transformation. Update strategy transformation is used to insert, update, and del...
Sequence Generator Transformation in Infotmatica
Vijay Bhaskar
Sequence generator transformation is a passive and connected transformation. The sequence generator transformation is used for Generatin...
Transaction Control Transformation in Informatica
Vijay Bhaskar
Transaction Control is an active and connected transformation. The transaction control transformation is used to control the commit and rol...
Joiner Transformation in Informatica
Vijay Bhaskar
The joiner transformation is an active and connected transformation used to join two heterogeneous sources. The joiner transformation joins...
Rank Transformation in Informatica
Vijay Bhaskar
Rank transformation is an active and connected transformation. The rank transformation is used to select the top or bottom rank of data. Th...
SQL Transformation in Script Mode Examples - Informatica
Vijay Bhaskar
This is continuation to my previous post on SQL Transformation in Query Mode . Here we will see how to use SQL transformation in script mod...
SQL Transformation in Informatica with examples
Vijay Bhaskar
SQL Transformation is a connected transformation used to process SQL queries in the midstream of a pipeline. We can insert, update, delete ...
Sorter Transformation in Informatica
Vijay Bhaskar
Sorter transformation is an active and connected transformation used to sort the data. The data can be sorted in ascending or descending or...
Router Transformation in Informatica
Vijay Bhaskar
Router transformation is an active and connected transformation. It is similar to the filter transformation used to test a condition and fi...
Union Transformation in Informatica
Vijay Bhaskar
Union transformation is an active and connected transformation. It is multi input group transformation used to merge the data from multiple...
Filter Transformation in Informatica
Vijay Bhaskar
Filter transformation is an active, connected transformation. The filter transformation is used to filter out rows in a mapping. As the fil...
Expression Transformation in Informatica
Vijay Bhaskar
Expression transformation is a connected, passive transformation used to calculate values on a single row. Examples of calculations are con...
Aggregator Transformation in Informatica
Vijay Bhaskar
Aggregator transformation is an active transformation used to perform calculations such as sums, averages, counts on groups of data. The in...
Transformations in Informatica 9
Vijay Bhaskar
What is a Transformation A transformation is a repository object which reads the data, modifies the data and passes the data. Transform...
Source Qualifier Transformation in Informatica
Vijay Bhaskar
The source qualifier transformation is an active,connected transformation used to represent the rows that the integrations service reads wh...
Case Converter Transformation in informatica
Vijay Bhaskar
The Case converter transformation is a passive transformation used to format the data to similar character formats. Case converter transfor...