• LOGIN
    • No products in the cart.

Overview:

Informatica Power Center is an ETL tool with visual interface to drag and drop different objects(transformations)  and design process flow diagrams(mappings) for data extraction transformation and load. Mapping are scheduled to run as and when required. Fetching of data from source, transforming and loading to external  systems(Systems/Databases). Power center can communicate with all major data sources like mainframe, Big Data, RDBMS, Flat Files, XML, SAP, Salesforce etc can move/transform data between them. Informatica can effectively integrate heterogeneous data sources & converting raw data into useful information.


Objectives:

  • Use Informatica Designer to build mappings that move data from sources to targets.
  • Understand workflow task and job handling.
  • Perform troubleshooting, error handling and recovery.
  • Use Informatica Powercenter ETL tool in real time projects.
  • Implement performance tuning methodology including performance counters, thread utilization, source, target, and integration service bottlenecks, and the impact of the update-else-insert setting.
  • Use PMCMD and PMREP command-line functionality.

Audience:

  • Software developers
  • Analytics professionals
  • ETL or Data warehouse professionals
  • Graduates who wanted to enter IT field
  • Mainframe developers and architects.

Prerequisites:

  • Thorough working knowledge of SQL, Unix, especially functions, joins, sub queries etc in SQL.
  • Knowledge of PL/SQL is also recommended, but not mandatory.

Share this...
Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn

Course Curriculum

INTRODUCTION TO DATAWAREHOUSING
INTRODUCTION TO DATAWAREHOUSING 00:00:00
INFORMATICA CLIENT COMPONENTS PW Designer
INFORMATICA CLIENT COMPONENTS PW Designer 00:00:00
Transformations
Transformations 00:00:00
PW Workflow manager
PW Workflow manager 00:00:00
PW Workflow monitor
PW Workflow monitor 00:00:00
PW Repository manager
PW Repository manager 00:00:00
Informatica Server components
Informatica Server components 00:00:00
Advanced Informatica
Advanced Informatica 00:00:00

Course Reviews

3.9

ratings
  • 1 stars0
  • 2 stars0
  • 3 stars0
  • 4 stars0
  • 5 stars0

No Reviews found for this course.

top
All Rights Reserved © 2016.  Powered By