Home   Jobs   SF Bay Area   Computer& Software Jobs   Developer -

Informatica PowerCenter 86 Developer Track Training | Technology Jobs in San Jose | Developer Jobs

Informatica PowerCenter 86 Developer Track Training

Posted on Oodle - 3 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 18 times.