• Data Integration Concepts
• ETL & ETL architecture
• Data Profile & Data Quality Management
• Brief on Data Warehousing

• Visualize PowerCenter client tools
• Create and execute the mapping
• Data Flow
• Transformations and their usage

• PowerCenter Workflow Manager
• Workflow Task & job handling
• Flow within a Workflow
• Components of Workflow Monitor
• Reusability and Scheduling in Workflow Manager

• Advanced transformations 
• XML File Processing and Transaction Processing
• Error handling features
• Cleaning the data 
• Reusability features

• Changed Data Capture, Constraint-Based Loading. Incremental Aggregation, etc.
• Loading Dimensional Tables
• Advanced techniques - Flat File, XML File

• PowerCenter Error
• Debugger
• Basic troubleshooting methodology
• Workflow & Session logs to diagnose errors
• Connection Errors and Network errors
• High Availability
• PowerCenter Environment
• Recovery scenarios and mechanisms
• Configure workflow and sessions for recovery

• Performance Tuning Methodology
• Mapping design tips and tricks
• Partition and Pushdown Optimization
• Caching and Memory Optimization
• Design Principles and Best Practices

• Repository Manager tool 
• PowerCenter Repository Maintenance

• Features of PowerCenter 10
• Overview of the PowerCenter Administration Console
• Integration & repository service properties
• Services in the Administration Console
• Users and groups

• Automate tasks via command-line programs
• Infacmd, infasetup, pmcmd, pmrep

• Buffer memory
• Connectivity among the tolls
• Informatica 10 Architecture
• Application services
• Connection Pooling

You don’t need any specific skills for the training. However, a basic working knowledge of SQL can be an added advantage.

• In-depth knowledge of the Informatica PowerCenter
• Comprehensive knowledge of various tools like Informatica Administrator Suite, Repository Manager, Designer, and Workflow Manager
• Capability to load Dimension Tables, use Advanced Transformation, recognize and repair Connection & Network Errors, configure Workflows & Sessions, create Users and Group and design Error Handling Strategies
• Hands-on knowledge of Informatica PowerCenter command-line tools
• Exposure to many real-life industry-based Business Intelligence Projects
• Rigorous involvement of an SME throughout the Informatica Training to learn industry standards and best practices

• Database is neutral and hence can communicate with any database
• It is one of the most powerful data transformations tool and converts one application’s data to another’s format

• Self-paced training
• Online Classroom
• Corporate training
• Instructor-led training

Yes, you can.

With Teaching Krow, you'll never miss a class. You'll have a recording even if you have missed a live class. Furthermore, you can also attend the same lecture in the next batch.

All the instructors at Teaching Krow are practitioners from the Industry with minimum 10-12 yrs of relevant IT experience. They are subject matter experts and are trained by Teaching Krow for providing an awesome learning experience to the participants.