[wpcol_1third id=”” class=”” style=””]

youtube

 

>>   Cognos

>>   Informatica

>>   Datastage

>>   Microstrategy

>>   AB-Initio

>>   Teradata

>>   OBIEE

>>   Hyperion

[/wpcol_1third] [wpcol_2third_end id=”” class=”” style=””]

INFORMATICA  

INFORMATICA 9.1 Online Training

Duration: 25 Hrs

DATAWAREHOUSING CONCEPTS:

INTRODUCTION TO DATAWAREHOUSING

  • What is Data warehouse?
  • Components of Data warehouse
  • Decision support systems
  • OLTP Systems
  • OLTP vs DATAWAREHOUSE
  • ODS(Operational Data Store)
  • Difference between ODS and DATAWAREHOUSE
  • Data Mart
  • Difference between Data warehouse and Data Mart
  • Difference between Data warehouse and ODS,OLTP
  • Data warehousing for OLTP systems
  • Data cleansing
  • Independent Data warehouse
  • Dependent Data warehouse
  • Meta data and Data Mining
  • OLAP,ROLAP,MOLA

DATABASE DESIGN AND DATA MODELING

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

TOOLS CONSIDERATION:

ERWIN (Data Modeling Tool)

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

INFORMATICA 8.6

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

INFORMATICA INSTALLTION

  • SYSTEM REQUIREMENT
  • CREATING DOMAIN
  • CREATING NODE
  • CONFIGURING DOMAIN WITH WEBSERVER
  • ASSIGNING INFORMATICA SERVICES WITH ACCOUNT

INFORMATICA POWERCENTER WEBADMINISTRATOR CONSOLE

  • Creating Informatica Repository Services
  • Creating integrated services

INFORMATICA REPOSITORY MANAGER

  • Creating the workspace(folder)
  • Creating the users
  • Changing the user passwords
  • Creating users groups
  • Giving privileges to the users, user groups and folder

INFORMATICA DESIGNER

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

TYPES OF TRANSFORMATIONS:

  • Source qualifier
  • Aggregator
  • Filter
  • Expression
  • Stored Procedure
  • Lookup
  • Sorter
  • Joiner
  • Router
  • Xml source qualifier
  • Update strategy
  • Normalizer
  • 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

WORKFLOW MANAGER

  • Components of workflow manager

Types of tasks

  • Session
  • E-mail
  • Command
  • Creating workflow
  • Scheduling the workflow
  • Creating connections
  • Assigning connection values to the sessions
  • Assigning server to workflow
  • Workflow monitor
  • Session logs
  • Workflow logs

[/wpcol_2third_end]

Leave a comment

Your email address will not be published.