bing
Flat 10% & upto 50% off + Free additional Courses. Hurry up!

Informatica Transformation

 

In Informatica Transformation source data can be transforming consistent with the necessities of target system and it guarantees the quality of data being loaded into target.

It is of two types- Active and Passive 

Active Transformation – With the help of Active transformation we can alter the no. of rows which is passes through the transformation and can alter the row type or transaction boundary. For example, Filter, Transaction Control and Update Strategy are active transformations.

The following are the list of active transformations used for processing the data –

  • Source quilter transformation
  • Filter transformation
  • Ruler transformation
  • Rank Transformation
  • Sorter transformation
  • Joiner transformation
  • Union Transformation
  • Aggregate Transformation
  • Transaction control transformation
  • Normalize transformation
  • Update strategy transformation
  • SQL Transformation

Go through the Informatica Course details so that you can get a better understanding of this widely used business intelligence tool.

Passive Transformation – With the help of passive transformation we cannot alter the no. of rows which goes through it and maintains the row type and transaction boundary.

The following are the list of passive transformations used for processing data.

  • Expression transformation
  • Sequence generated transformation
  • Stored procedure transformation
  • Look up transformation
  • XML source qualifier transformation
  • SQL Transformation

Looking for top jobs in Business Intelligence ? This blog post gives you all the information you need!

Transformations can be Connected or Unconnected to the data flow.

Connected Transformation – Connected transformation is linked to other transformations or directly to destination table in the mapping.

Unconnected Transformation – Unconnected transformation is not linked to other transformations in the mapping. It is invoked within a different transformation and gives a value to that transformation.

These are the transformation list in Informatica –

Transformation    Type   Description
Aggregator Active/Connected Performs aggregate calculations.
Application Source Qualifier Active/Connected Represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a session.
Custom Active or Passive/Connected Calls a procedure in a shared library or DLL.
Data Masking Passive/Connected Replaces sensitive production data with realistic test data for non-production environments.
Expression Passive/Connected Calculates a value.
External Procedure Passive/Connected or Unconnected Calls a procedure in a shared library or in the COM layer of Windows.
Filter Active/Connected Filters data.
HTTP Passive/Connected Connects to an HTTP server to read or update data.
Input Passive/Connected Defines mapplet input rows. Available in the Mapplet Designer
Java Active or  Passive/Connected Executes user logic coded in Java. The byte code for the user logic is stored in the repository
Joiner Active/Connected Joins data from different databases or flat file systems.
Lookup Active or Passive/Connected or Unconnected Lookup and return data from a flat file, relational table, view, or synonym.
Normalizer Active/Connected Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.
Output Passive/Connected Defines mapplet output rows. Available in the Mapplet Designer.
Rank Active/Connected Limits records to a top or bottom range.
Router Active/Connected Routes data into multiple transformations based on group conditions.
Sequence Generator Passive/Connected Generates primary keys.
Sorter Active/Connected Sorts data based on a sort key.
Source Qualifier Active/Connected Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.
SQL Active or Passive/Connected Executes SQL queries against a database.
Stored Procedure Passive/Connected or Unconnected Calls a stored procedure.
Transaction Control Active/Connected Defines commit and rollback transactions.
Union Active/Connected Merges data from different databases or flat file systems.
Unstructured Data Active or Passive/Connected Transforms data in unstructured and semi-structured formats.
Update Strategy Active/Connected Determines whether to insert, delete, update, or reject rows.
XML Generator Active/Connected Reads data from one or more input ports and outputs XML through a single output port.
XML Parser Active/Connected Reads XML from one input port and outputs data to one or more output ports.
XML Source Qualifier Active/Connected Represents the rows that the Integration Service reads from an XML source when it runs a session.

"0 Responses on Informatica Transformation"

Training in Cities

Bangalore, Hyderabad, Chennai, Delhi, Kolkata, UK, London, Chicago, San Francisco, Dallas, Washington, New York, Orlando, Boston

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

top

Sales Offer

  • To avail this offer, enroll before 05th December 2016.
  • This offer cannot be combined with any other offer.
  • This offer is valid on selected courses only.
  • Please use coupon codes mentioned below to avail the offer
offer-june

Sign Up or Login to view the Free Informatica Transformation.