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 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 !!