Follow Community Blog Topics about Informatica Transformations ― Join the largest Bloggers Community to follow latest blog posts about Informatica Transformations and discover the Best Bloggers or Top Blogs from around the world, and build your audience now!

Informatica Transformations

Unconnected Stored Procedure Transformation Example - Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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 ...

Tags: Informatica, Informatica Transformations

Vijay ― 4 weeks 4 days ago

Stored Procedure Transformation Example In Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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 ...

Tags: Informatica, Informatica Transformations

Vijay ― 4 weeks 5 days ago

Stored Procedure Transformation in Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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...

Tags: Informatica, Informatica Transformations

Vijay ― 4 weeks 6 days ago

Lookup Transformation in Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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...

Tags: Informatica, Informatica Transformations

Vijay ― 20 May, 12

Update Strategy Transformation in Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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...

Tags: Informatica, Informatica Transformations

Vijay ― 15 May, 12

Sequence Generator Transformation in Infotmatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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 ...

Tags: Informatica, Informatica Transformations

Vijay ― 11 May, 12

Transaction Control Transformation in Informatica

Transaction Control Transformation in Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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, ...

Tags: Informatica, Informatica Transformations

Vijay ― 26 Apr, 12

Joiner Transformation in Informatica

Joiner Transformation in Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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 ...

Tags: Informatica, Informatica Transformations

Vijay ― 12 Apr, 12

Rank Transformation in Informatica

Rank Transformation in Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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 ...

Tags: Informatica, Informatica Transformations

Vijay ― 26 Mar, 12

SQL Transformation in Script Mode Examples - Informatica

SQL Transformation in Script Mode Examples - Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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...

Tags: Informatica, Informatica Transformations

Vijay ― 14 Mar, 12

SQL Transformation in Informatica with examples

SQL Transformation in Informatica with examples

Informatica, Unix, Oracle, Netezza Tutorials ― 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 ...

Tags: Informatica, Informatica Transformations

Vijay ― 13 Mar, 12

Sorter Transformation in Informatica

Informatica, Unix, Oracle, Netezza Tutorials ― 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...

Tags: Informatica, Informatica Transformations

Vijay ― 5 Mar, 12

Popular

Banana Ballz

by Shannon R ∙ 1 day ago

I love having raw quick things in the fridge for snacks. Want something sweet? It’s ...

Bronze Babe

by Blonde Episodes ∙ 13 hr ago

The time is upon us to be tan and fit. I love this time of year. The best way to get ...

Crockpot Mushroom Wine Chicken and Wild Rice Recipe

by Pegasuslegend ∙ 1 day ago

Crockpot Mushroom Wine Chicken and Wild Rice Recipe

Crock pot cooking is perfect for anyone on the go go go! Well here is a great dinner that ...