Informatica online training India

1
Informatica Online Training

• By CRS Info Solutions

CRS Info Solutions
2
About Informatica Online Training

• CRS Info Solutions is best Informatica Training
  institute in India. CRS Info Solutions have
  training for all groups of people from learner to
  advanced level professionals. We provides the
  training to the learners in different concepts
  and modes to be the vital in the current Job
  market, having quality,skilled and current
  Industry expert trainers. And also provides
  training on complete project (END TO END) with
  real time. so you can expect the best Informatica
  online training with us.

3
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

4
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

5
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

6

• 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

7

• 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
• Creating a Folder
• Folder Permissions
• Creating shortcuts

8

• DESIGNER
• Types of Transformations
• Connected and Unconnected Transformations
• Active and Passive Transformations
• Creating Source Tables
• 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

9

• Aggregator Transformation
• Expression Transformation
• Lookup Transformation (Connected and Un
  Connected)
• Union Transformation
• Joiner Transformation
• Normalizer Transformation
• SQL Transformation
• Filter Transformation
• Sequence Generator Transformation
• Source Qualifier Transformation
• Router Transformations
• Rank Transformations

10

• XML Parser Transformation
• XML Generator Transformation
• SQL Override in source qualifier Transformation
  and lookup Transformation
• Connecting the Target
• Connecting Transformations
• Creating a Mapping
• Completing the Mapping
• Creating a Mapping with Aggregate Values
• Target load order plan
• Mapping wizards
• Reusable Transformation

11

• WORKFLOW MANAGER
• Creating the Session
• Creating the Workflow
• 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

12

• 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
• Monitoring the jobs
• How to get Session Logs and Workflow Logs
• Real time Questions and Answers
• Exercises for each Transformation
• Datawarehosuing Concepts

13
Contact Us

• CRS Info Solutions
• Visit www.crsinfosolutions.com/courses/informatic
  a/
• Informatica Online Training