|
|
|
|
|
Informatica Power Center 8.x |
|
Software Version |
Informatica Power Center 8.x |
Course Duration |
5 Days |
Course Type |
Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training |
|
Course Overview |
This intensive course provides the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects, exposing core features of PowerCenter releases 8.0 to 8.6 through lecture and hands-on exercises.. In addition to gaining tremendous insight into the data integration platform, students will be exposed to troubleshooting techniques.
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.
- Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 8.
|
Intended Audience for this course |
This course is designed for those who have technical background, knowledge with any computer language, Java, J2EE, XML, .NET Developers, Business Intelligence Developer, Data warehouse Administrator, Data Modelers, End Users, ERP Developers, DBAs, Functional Consultants, IT management and Staff, Business Analysts, Data Warehouse Analysts, Technical Consultants, Students and also those who want to become Informatica consultants. |
|
Course Topics |
|
|
Overview |
|
- 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
- Update Strategy
- Joiner Transformation
- Rank Transformation
- Sequence Generator
- XML Transformation (Generator & Parser, both)
- Creating, Configuring and Linking Ports
- Joiner Transformation
- Stored Procedure Transformation
- Union Transformation
- Sorter Transformation
- ODBC DSN creation
- Designing the ETL
- Specifying the Database Connections
- Troubleshooting Informatica
|
|
|
|
|
|
|
|
|
|
|
Follow us on .....
|
|
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved. |
|
|
|