informatica online training from India |informatica online training institutes - PowerPoint PPT Presentation

About This Presentation
Title:

informatica online training from India |informatica online training institutes

Description:

Sudeep Technologies Informatica online training from India provides online training course with real time experts.Best informatica online training call us to +91 9700042555 ,040-65240555. 1).Introduction to Data Warehousing 2). Database Design and Data Modelling 3).ERwin (Data Modelling Tool) 4).Informatica 8.6 5).Informatica installation 6).Informatica Power Centre Web Administration Console 7).Informatica Repository Manager 8).Informatica Designer 9).Types of Transformations 10).Workflow Manager 11).Types of tasks – PowerPoint PPT presentation

Number of Views:45

less

Transcript and Presenter's Notes

Title: informatica online training from India |informatica online training institutes


1
INFORMATICA ONLINE TRAINING
2
INFORMATICA
  • SUDEEP Technologies is one of the leading
    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
  • Contact us
  • 91 9700042555, 040-65240555
  • Auto Nagar, Terminal, krishna Nagar,
    Vijayawada-520007
  • Website URL
  • http//www.sudeeptechnologies.com/courses/dataware
    -housing/informatica-online-training/57
Write a Comment
User Comments (0)
About PowerShow.com