Informatica Online Training

Zenith Trainings's Informatica Online Training will train you on how to administer the tool efficiently, and to upgrade your skills to the latest version. This Informatica course provides you the overview of Informatica PowerCenter Product and its installation, the concepts of data integration & data warehousing.

You can learn how different development units of PowerCenter can be used to create a simple mapping. The Informatica Course instigates you to advanced transformation techniques and ETL scenarios using Informatica 10. You can understand the features provided by Informatica to debug, troubleshoot and handle errors.

You will learn the best practices for optimum performance of your ETL process and to manage the repository effectively. An overview of the PowerCenter administration console is given, and you can recognize and be able to explain integration and repository service properties. The Informatica Online Training Course will also deal with command line aspect of Informatica PowerCenter.

Fundamentals of ETL(Extraction Transformation and Loading) :
  • Data Extraction
  • Data Transformation
  • Data Loading
Fundamentals of DWH (Dataware Housing):
  • What is Data warehousing
  • Difference between OLTP and OLAP
  • Difference between Normalized data and De-Normalized data
  • Difference between Star schema & Snow Flake Schema
  • Difference between Database, Dataware house, Datamart
  • What is the Source system, Staging Layer, DWH Layer/ Presentation Layer
  • What is Stage table, Dimension Table and Fact table
  • Benefits of maintaining Dataware house
Informatica Power Center : Informatica Tools:
  • Designer
  • Workflow Manager
  • Monitor
  • Repository Manager
  • Informatica Repository Administration Console
Designer Source Analyzer
  • Importing & creating various types of source definitions
  • Database (RDBMS), Flat Files, XML, MS-EXCEL etc
Target Designer
  • Importing & creating various types of target definitions
  • Database (RDBMS), Flat Files, XML etc
Fundamentals of Transformations
  • What is transformation
  • Difference between Active and Passive Transformations
  • Difference between Connected and Unconnected Transformations
  • Difference between Re-usable and Non-reusable Transformations
Transformations
  • Filter, Router, Sorter, Rank, UNION, Joiner, Expression, Aggregator, Source Qualifier, Normaliser, Sequence Generator, Lookup, Update Strategy, Stored Procedure
Transformation Developer :
  • Creating Reusable Transformations
Mapplet Designer:
  • Creating Mapplets
User Defined Functions (UDF) Error Handling and Debugging
  • Stop on Errors
  • Override Tracing Levels
Incremental Aggregation Concepts of Parameter file, Mapping Parameters & Variables
  • The concept of Parameters & Variables:
  • Mapping Parameters
  • Mapping Variables
  • Built-in Variables
  • Server Variables
  • Session Variables
  • Workflow Variables
  • Implementation of Delta/Incremental load using Mapping Variables
Concepts of Informatica Cache’s
  • Index Cache, Data Cache, Static Cache, Dynamic Cache & Persistent Cache
Maintaining Historical data in Dataware houses using Concepts of Slowly Changing Dimensions (SCD’s):
  • Type1
  • Type2
  • Using Effective Date Ranges
  • Using Flag/ Indicator Column
  • Using Versioning
  • Type3
  • Type6(1+2+3) Hybrid Approach
Configuring Lookup Transformation with Dynamic Cache Workflow Manager
  • Basic Session Properties
Load types :
  • Normal Vs Bulk
Target Properties:
  • Insert
  • Update
  • Update as Insert, Update as Update and Update else Insert
  • Delete
  • Truncate table
Treat Source Rows As Property Difference between a task, Worklet and Workflow Link Conditions Different types of tasks: Re-usable:
  • Session, Command, Email
Non-Reusable
  • Timer , Control ,Decision ,Assignment ,Event- raise ,Event-Wait
Scheduling a Workflow Workflow Monitor:
  • Monitoring Sessions & Workflows
  • Read and Understand Workflow, Session Log files
  • Identify errors from Log files
  • Re-start, stop, Abort tasks & workflows
Advanced Concepts:
  • Overview of Performance Tuning & Tuning Guidelines
  • Basics of Pipeline Partitioning
  • Introduction to Push Down Optimization(PDO)
  • Overview of Informatica Power Center Architecture
  • Basics of Informatica Power Center Administration
  • Code import, Export & Deployment
  • User Management: Create Users, Groups, Roles
  • Creating Folders
Miscellaneous Concepts:
  • Target Load Plan
  • Generate Execute
  • Shortcuts Vs Copies
  • Stop Vs Abort
  • Start Vs Cold Start
  • Overview of Load Manager(LM)
  • Overview of Data Transformation Manager(DTM)
  • Concepts of Overriding
  • Overview of ETL Designing
  • Overview of ETL Testing
  • A Small Case Study
About the Trainer:
  • Real-Time working  and Certified Professional
  • Has experience in delivering Corporate Trainings
  • Has overall experience of 12+ years in IT
  • 10+ Years real time work experience in Informatica
  • Delivered projects  or POCs on Informatica

Q.Why Should I Learn Informatica From Zenith Trainings?

Zenith Trainings is the pioneer of online training in Business Intelligence in India. Informatica is clearly a market leader in the fields of data integration and data quality services. The Informatica Power Center is a powerful tool to integrate, manage and migrate enterprise data.
This training course is completely in line with clearing the Power Center Developer Certification, and Power Center Administrator Certification. We provide a hands-on, fast-paced training with real world projects and assignments that are designed keeping in mind the industry needs.
Upon completion of the Informatica training course you can apply for some of the best jobs in top MNCs around the world at top salaries. Zenith Trainings offers lifetime access to videos, course materials, 24/7 Support, and course material upgrading to latest version at no extra fees. Hence it is clearly a one-time investment.

Q.Does Zenith Trainings Offer Job Assistance?

Zenith Trainings actively provides placement assistance to all learners who have successfully completed the training. For this we are exclusively tied-up with over 75 top MNCs from around the world. This way you can be placed in outstanding organizations like Sony, Ericsson, TCS, Cognizant, Cisco, among other equally great enterprises. We also help you with the job interview and resume preparation part as well.

Sudheer Neralla

Well, I took this Informatica online training course from Zenith Trainings and now I am an expert in this ETL and business intelligence tool. I highly recommend Zenith Trainings Informatica course to everybody.

Bhanukumar Muppalla

The Zenith Trainings training and the support that they offered were really top quality. I have only positive reviews for the entire Informatica online training. Great to learn at Zenith Trainings!

Contact Us

 +91 63051 49934

Offer :
Get Self-Paced Videos Free With This Course!

Self-Paced ($300)

  • Lifetime access with high-quality content and class videos
  • 40 hours of course presentations by hands-on experts
  • 26 hours of lab time
  • 24×7 online support

Live Online Training ($300)

Mon -Fri (6 Weeks)——————————————————
Mon -Fri (6 Weeks)

Project Support ($500)

  • Daily 2 hours session
  • 6 Days support per week