INFORMATICA 9.6.1 REAL TIME TRAINING IN INDIA

At the end of this course you will – Understand how to use all major Power Center 9.x components Data warehousing concepts ORACLE database sql (writing sql queries) Be able to perform basic Repository administration tasks Be able to build ETL Mappings and Mapplets Understand the different Transformations and their attributes in PowerCenter 9.x Be able to create, run and monitor Workflows Be able to troubleshoot common development problems Understand the Architecture of Informatica `Differcence between powercentrer 9.x and previous versions (8.x,7.x) Introduction to Informatica tool Mapping Design Process Introduction to ETL Tools Power Center Client Interface Mapping Components Source Objects Target Definitions Creating Physical Tables Workflow and Session Executing the Workflow Extracting data from Oracle Table and Load it to DB Extracting data from Flat File and Load it to Oracle DB