Online Training Informatica

1
Informatica Online Training

• By CRS Info Solutions

CRS Info Solutions
WELCOME TO Informatica Online Training
Attend Free Online Demo
2
About Informatica Online Training

• CRS Info Solutions is one of the best leading
  Online Training Company involved in providing
  INFORMATICA ONLINE TRAINING. Our Trainers are
  expert in providing Online Training with real
  time experience.
• Informatica Concepts
• Introduction to Data Warehousing
•  Database Design and Data Modelling
• Informatica 8.6
• Informatica installation
• Informatica Power Centre Web Administration
  Console
• Informatica Repository Manager
• Informatica Designer
• Types of tasks

3
Introduction to Data Warehousing

• What is Data warehouse?
• Components of Data warehouse
• Decision support systems
• ODS(Operational Data Store
• Difference between ODS and DATAWAREHOUSE
• OLTP Systems
• OLTP vs DATAWAREHOUSE
• Data Mart
• Difference between Data warehouse and Data Mart
• Difference between Data warehouse and ODS, OLTP
• Data cleansing

4
Database Design and Data Modelling

• Introduction to Data Modelling
• What is the use of data modelling in Data
  warehousing?
• ER Model for transactional processing
• Entities and Attributes
• Schema
• Star Schema
• Snowflake Schema
• Snowflake Schema(hybrid schema or galaxy schema)
• Fact Table
• Dimension Tables
• Multi dimension Tables

5
Informatica 8.6

• Introduction of Informatica power centre
• ETL Architecture
• Data source
• Data targets
• Meta data
• Repository
• Client components
• Server components

6
Informatica installation

• System Requirements
• Creating Domain
• Creating Node
• Configuring Domain With Web Server
• Assigning Informatica services with Account
• Informatica Power Centre Web Administration
  Console
• Creating integrated services
• Creating Informatica Repository Services

7
Informatica Repository Manager

• Creating the workspace(folder)
• Creating the users
• Changing the user password
• Creating users groups
• Informatica Designer
• Connecting to the designer
• Components of the designer
• Creating DSN(data source name)
• Source, Database
• Warehouse Designe
• Accessing the source, definitions to the designer

8
Types of tasks

• Session
• Assigning connection values to the sessions
• Command
• Creating workflow
• Scheduling the workflow

9
What we offer in online Informatica course?

• We offer very unique online training as compare
  to other training providers in the market. Our
  training will make you to get the right
  information for to organize the data for the
  smooth operation of your firm. Our course contain
  below concepts
• How to handle the errors with power center
  mappings.
• How to develop work flow manager installation.
• How operate work flow to integrate with mapping.
• How to develop work flow and mappings to meet the
  needs of your business.
• How to develop power center logs and debuggers in
  trouble shooting.

10
Informatica Online Training Course Highlights

• Online training by certified expertise tutors.
• Highly advanced hands-on cloud based labs.
• Teaching by real time expertise from informatica.
• Get accessed to course material from anywhere
  with internet access.
• Visually navigated teaching methodologies.
• Get accessed to subject material on 24/7.
• Certification assistance to the interested
  candidates.
• Training in preparation of audio and video
  presentations.
• Training in preparation of workflows.
• Job assistance in resume and interview
  preparation.
• Real time scenario based subject material
  applicable to your business.

11
Contact Us

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