Scripting School Provides Ant Online Training , AngularJS Online Training, Backbone js Online Training , Node.Js Online Training , JavaScript Online Training, LUA Online Training, Groovy Scripts Online Training , Groovy on Grails Online Training , HTML5 Online Training , Maven Online Training , Perl Script Online Training , PowerShell Online Training , Python Online Training , PHP Online Training , Ruby Script Online Training , Ruby on Rails Online Training , R Scripts Online Training , TCL Script Online Training , Unix Shell Script Online Training , VBScript Online Training ,Hadoop Online Training, Advanced Java Online Training, Core Java Online Training, Hibernate Online Training, J2EE Online Training, Spring Online Training, .NET Online Training, Microsoft BI Online Training, Microsoft SSAS Online Training, Microsoft SSIS Online Training, Microsoft SSRS Online Training, SharePoint BI Online Training, SharePoint Online Training, Windows Server 2008 Admin Online Training, Cognos Online Training, Datastage Online Training, Informatica Online Training, OBIA Online Training, OBIEE Online Training, Teradata Online Training, Advanced Perl Online Training, Android Online Training, Drupal Online Training, Joomla Online Training, PHP Online Training, Python Online Training, Salesforce Online Training, SAS Clinical Online Training, SEO Online Training, Veritas Volume Manager Online Training, Web Designing Online Training.

1).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
  • Data Mart
  • Difference between Data warehouse and Data Mart
  • Difference between Data warehouse and ODS, OLTP
  • Data warehousing for OLTP systems
  • Dependent Data warehouse
  • Independent Data warehouse
  • Meta data and Data Mining
  • Data cleansing

2). 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
  • Granularity for the Data warehousing
  • Grain warehousing Tools consideration

Tools Consideration:

3).ERwin (Data Modelling Tool)

  • Introduction to ERwin
  • Usage of ERwin
  • Physical and Logical Model
  • Creation of Table
  • Forward Engineering
  • Reverse Engineering
  • Complete compare
  • Subject areas
  • Relationships
  • Domains
  • Demoralization
  • Data Modelling report generation
  • HTML report
  • RTF report
  • Text report
  • Creating user defined data types
  • Integrating Tables from different users

4).Informatica 8.6

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

5).Informatica installation

  • System Requirements
  • Creating Domain
  • Creating Node
  • Configuring Domain With Web Server
  • Assigning Informatica services with Account

6).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
  • Giving privileges to the users, user groups and folder

8).Informatica Designer

  • Connecting to the designer
  • Components of the designer
  • Creating DSN(data source name)
  • Source, Database
  • Warehouse Designer
  • Accessing the source, definitions to the designer
  • Creating the target Tables using warehouse designer
  • Generating target Table to database
  • Transformations between source and target Tables
  • Mapping Designer
  • Mapping between the source and target Tables

9).Types of Transformations:

  • Source qualifier
  • Aggregator
  • Filter
  • Expression
  • Stored Procedure
  • Lookup
  • Sorter
  • Joiner
  • Router
  • Xml source qualifier
  • Update strategy
  • Normaliser
  • Ranking
  • Sequencer Generator
  • Transaction control
  • Union
  • Custom
  • Cubes and Dimensions(creating star schema)
  • Slowly Changing Dimensions(SCD) Mapplets
  • Reusable transformations Debugger
  • Working with mapping using Debugger
  • Data Profiling
  • Variable and Parameters
  • New Features in power centre 7.1

10).Workflow Manager:

  • Components of workflow manager

11).Types of tasks:

  • Session
  • Assigning connection values to the sessions
  • Command
  • Creating workflow
  • Scheduling the workflow
  • Assigning server to workflow
  • Workflow monitor
  • E-mail
  • Session logs
  • Workflow logs
Informatica Online Training institute in Hyderabad