What is Informatica Powercenter

Learn What is inforamatica powercenter and its uses, Informatica powercenter designer,informatica powercenter repository, oltp system informatica,olap system informatica,informatica powercenter etl processing

1. What is Informatica Powercenter ?

2. WHY DATA INTEGRATION?

3. OLTP SYSTEM Operational data is the data you use to run your business. This data is what is typically stored, retrieved, and updated by your Online Transactional Processing (OLTP) system. An OLTP system may be, for example, a reservations system, an accounting application, or an order entry application. OLAP SYSTEM Informational data is created from the wealth of operational data that exists in your business and some external data useful to analyze your business. Informational data is what makes up a data warehouse.

4. Informatica PowerCenter is one of the Enterprise Data Integration products developed by Informatica Corporation. Informatica PowerCenter is an ETL tool used for extracting data from the source, transforming and loading data in to the target. The Extraction part involves understanding, analyzing and cleaning of the source data. Transformation part involves cleaning of the data more precisely and modifying the data as per the business requirements. Loading part involves assigning the dimensional keys and loading into the warehouse. ETL Process in Informatica Powercenter is called as Mapping WHAT IS INFORMATICA POWERCENTER ?

5. Sample Mapping

6. Different Versions                                                                                                                               Version            Release Date 6.x                     September 2002 7.x  March 2004 8.1.x  May 2006 8.5.x October 2007 8.6.x  June 2008 9.0.x 9.1 9.5.x   9.6  December 2009  March 2011 June 2012 Feb 2014

7. Learn Informatica Contact: USA: [phone] India: [phone] Mail: [email protected] / bigclasses / bigclasses / bigclasses http://bigclasses.com/informatica-online-training.html

8. Thank you Watch Informatica DEMO Videos On YouTube www.youtube.com/user/bigclassescom