Informatica Online Training in USA, UK, Canada & India Syllabus

1
ONLINE TRAINING
INFORMATICA
Contact 91-9642373173 Mail
info_at_svsoftsolutions.com USA 1-845-915-8712
Visit www.svsoftsolutions.com
2
About Informatica Online Training

• SV Soft Solutions is best Informatica Training
  institute in Hyderabad. SV Soft Solutions have
  training for all groups of people from learner to
  advanced level professionals. We have trained
  more than 1000 students around the world and
  placed them in 500 fortune companies. Our Hadoop
  Online Training will be provided worldwide like
  USA, UK, Canada and India. We provide best
  Informatica Online Certification Training with
  real time and job oriented sessions.

3
Informatica Training Highlights

• Detailed course material with real time examples
• Informatica classes with expert trainers
• 24x7 customer support
• We are giving placement support in companies in
  USA, Canada and India
• Certification oriented Informatica training

4
Who Should Take Informatica Training?

• System Administrators
• Programing Developers
• Project Managers
• IT Professionals
• Testing Professionals
• Mainframe Working Professionals
• Graduates or Undergraduates who are interested to
  learn Informatica Online Course

5
Informatica Course Benefits

• Industry Expert Trainer
• Real time Scenario
• Doubt session Support
• Topic to Topic Assignments
• Resume Preparation
• Interview Q/A
• Record Sessions
• Detailed Study Material
• 24/7 Support

6
About Trainer

• Informatica Training will be delivered by well
  qualified, professional who have good experience
  to handle any kind of Hadoop issues. Our Trainers
  are officially working in MNC, so they share
  their experience with learners.

7
Informatica Online Training Syllabus

• History of Informatica
• Opportunities of Informatica
• Other ETL tools
• Power centre Administration
• Informatica Power centre architecture
• Power centre components
• ETL Plan
• Power centre Clients
• Designer
• Workflow manager

8

• Work Flow monitor
• Workflow manager
• Repository manager
• Power center repository
• Administrative tool
• Repository services
• Integration services
• Power center domain
• Application services
• Concept of nodes and grid

9

• Service manager
• Power center administration console
• Repository Administration
• Creating Repository Users and Groups
• Connecting to the Repository
• Creating a Group
• Assigning Privileges to a Group
• Creating a User

10

• Creating a Folder
• Folder Permissions
• Creating shortcuts
• DESIGNER
• Types of Transformations
• Connected and Unconnected Transformations
• Active and Passive Transformations
• Creating Source Tables

11

• Creating Target Definitions
• Creating Target Tables
• Creating source definitions
• Creating a Mapping
• Connecting Transformations
• Transformation Creation
• Importing sources and targets (database objects)
• Importing sources and targets (flat files and XML
  files)
• Using Transformations

12

• Aggregator Transformation
• Expression Transformation
• Lookup Transformation (Connected and Un
  Connected)
• Union Transformation
• Joiner Transformation
• Normalizer Transformation
• SQL Transformation
• Filter Transformation

13

• Sequence Generator Transformation
• Source Qualifier Transformation
• Router Transformations
• Rank Transformations
• XML Parser Transformation
• XML Generator Transformation
• SQL Override in source qualifier Transformation
  and lookup Transformation
• Connecting the Target
• Connecting Transformations

14

• Creating a Mapping
• Completing the Mapping
• Creating a Mapping with Aggregate Values
• Target load order plan
• Mapping wizards
• Reusable Transformation
• WORKFLOW MANAGER
• Creating the Session
• Creating the Workflow

15

• Using the workflow manager
• Creating Sessions and Workflows
• Configuring Database Connections in the Workflow
  Manager
• Creating a Reusable Session
• Creating a Workflow
• Running and Monitoring Workflows
• Opening the Workflow Monitor
• Workflow Tasks
• Session

16

• Assignment task
• Link task
• Post session and Pre-session commands
• Commit points
• Mapping and session parameter
• Pushdown optimization
• WORKFLOW MONITOR
• How to monitor loads
• Uses of Workflow monitor

17

• Monitoring the jobs
• How to get Session Logs and Workflow Logs
• Real time Questions and Answers
• Exercises for each Transformation
• Datawarehosuing Concepts

18
Contact Us

• For More Information about training
• Website www.svsoftsolutions.com
• Email info_at_svsoftsolutions.com
• Phone USA 1-845-915-8712
• India 91-9642373173