ETL Tool – Informatica – Part 2

Power Exchange: Informatica Power Exchange as a stand alone service or along with Power Center, helps organizations leverage data by avoiding manual coding of data extraction programs. Power Exchange supports batch, real time and changed data capture options in main frame (DB2, VSAM, IMS etc.), mid range (AS400 DB2 etc.,), and for relational databases (oracle,…

Read More

ETL Tool – Informatica – Part 1

Informatica: Informatica is a powerful ETL tool from Informatica Corporation, a leading provider of enterprise data integration software and ETL software. The important Informatica Components are: Power Exchange Power Center Power Center Connect Power Exchange Power Channel Metadata Exchange Power Analyzer Super Glue In Informatica, all the Metadata information about source systems, target systems and…

Read More

Informatica Transformations – Part 5

XML Source Qualifier Transformation: XML Source Qualifier is a Passive and Connected transformation. XML Source Qualifier is used only with an XML source definition. It represents the data elements that the Informatica Server reads when it executes a session with XML sources. Advanced External Procedure Transformation: Advanced External Procedure transformation is an Active and Connected…

Read More

Informatica Transformations – Part 4

Sequence Generator Transformation: Sequence Generator transformation is a Passive and Connected transformation. It is used to create unique primary key values or cycle through a sequential range of numbers or to replace missing keys. It has two output ports to connect transformations. By default it has two fields CURRVAL and NEXTVAL(You cannot add ports to…

Read More

Informatica Transformations – Part 2

Aggregator Transformation: Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups). For example, to calculate total of daily sales or to calculate average of monthly or yearly sales. Aggregate functions such as AVG, FIRST, COUNT,…

Read More

Informatica Transformations – Part 1

What are Informatica Transformations? [Submitted by: Radhika, Michigan, US.] In Informatica, Transformations help to transform the source data according to the requirements of target system and it ensures the quality of the data being loaded into target. Transformations are of two types: Active and Passive. Active Transformation: An active transformation can change the number of rows…

Read More
error: Content is protected !!