This is continuation to my previous post on connected stored procedure transformation example. Here I am going to use the same stored procedure which was used in the connected stored procedure transformation example. Please check the connected ...―
In this article, we will see how to create a connected stored procedure transformation using a simple example. ∙ Example: Lets consider the employees table in the oracle database as the source. We will create a stored procedure in the ...―
Stored Procedure Transformation is a passive transformation. Stored procedure transformation can be used in both connected and unconnected mode. ∙ Stored procedures are stored and run within the database. Stored procedures contain a...―
Lookup transformation is used to look up data in a flat file, relational table, view or synonym. Lookup is a passive/active transformation and can be used in both connected/unconnected modes. From informatica version 9 onwards lookup is an active...―
Update strategy transformation is an active and connected transformation. Update strategy transformation is used to insert, update, and delete records in the target table. It can also reject the records without reaching the target table. When you...―
Sequence generator transformation is an active and connected transformation. The sequence generator transformation is used for ∙ Generating unique primary key values.Replace missing primary keysGenerate surrogate keys for dimension tables ...―
Transaction Control is an active and connected transformation. The transaction control transformation is used to control the commit and rollback of transactions. You can define a transaction based on varying number of input rows. As an example, ...―
The joiner transformation is an active and connected transformation used to join two heterogeneous sources. The joiner transformation joins sources based on a condition that matches one or more pairs of columns between the two sources. The two ...―
Rank transformation is an active and connected transformation. The rank transformation is used to select the top or bottom rank of data. The rank transformation is used to select the smallest or largest numeric/string values. The integration ...―
This is continuation to my previous post on SQL Transformation in Query Mode. Here we will see how to use SQL transformation in script mode. ∙ Script Mode ∙ In a script mode, you have to create the sql scripts in a text file. The SQL...―
SQL Transformation is a connected transformation used to process SQL queries in the midstream of a pipeline. We can insert, update, delete and retrieve rows from the database at run time using the SQL transformation. ∙ The SQL ...―
Sorter transformation is an active and connected transformation used to sort the data. The data can be sorted in ascending or descending order by specifying the sort key. You can specify one or more ports as a sort key and configure each sort key...―
I love having raw quick things in the fridge for snacks. Want something sweet? It’s ...
The time is upon us to be tan and fit. I love this time of year. The best way to get ...
Crock pot cooking is perfect for anyone on the go go go! Well here is a great dinner that ...