Informatica PowerCenter 86 Developer Track Training
Posted on Oodle - 2 weeks ago
- Company:
- BI-Dw Solutions
- Location:
- San Jose, CA
Features & Description
After successfully completing this course, students should be able to:> Use PowerCenter 8 Designer to build mappings that move data from sources to targets.
> Use PowerCenter 8 Workflow Manager to build and run a workflow that runs a session based on a mapping.
> Design mappings and workflows based on business needs.
> Perform basic troubleshooting of PowerCenter mappings and transformaitons.
The Topics and Fundamentals to be discussed during the course include, but not limited to :-
Understanding the scope of Data warehouse project
Informatica and Data warehousing
Informatica Architecture
Informatica Server
ETL with Informatica
Informatica Suite Components
Informatica Designer
Workflow Monitor
Source Analyzer
Warehouse Designer
Mapping Designer
Mapplets Designer
Transformations in Informatica
Importing sources and Targets
Source Qualifier Transformation
Filter Transformation
Expression Transformation
Aggregator Expression
Router Transformation
Lookup Transformation
Rank Transformation
Union Transformation
Sequence Generator
XML Transformation (Generator & Parser, both)
New Functions in version 8
Stored Procedure Transformation
Creating, Configuring and Linking Ports
Joiner Transformation
Sorter Transformation
ODBC DSN creation
Designing the ETL
Specifying the Database Connections
This ad has been viewed 16 times.
