BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

bestwaytechnologies@gmail.com

INFORMATICA


BESTWAY Technologies offering  best Data warehouse INFORMATICA Training in Bangalore and Hyderabad with Real time most experienced working Professionals.  Our INFORMATICA trainer is working in INFORMATICA and total 13+ years experience in INFORMATICA.  we cover under this INFORMATICA course Syllabus major topics DATAWAREHOUSING CONCEPTS, Data Modeling, Slowly Changing Dimensions(SCD), Introduction of Informatica power center, INFORMATICA REPOSITORY MANAGER, INFORMATICA DESIGNER, TYPES OF TRANSFORMATIONS, WORKFLOW MANAGER, ETL Performance Tuning, Best Practices. We are plain to INFORMATICA  Course Content basic concepts to advanced level in-depth content. We are offers weekdays Batch (Monday to Friday)for day 1 to 1:30 hour, weekend batch (Saturday and Sunday ) for day 3hour class & Fast track which is based on your timings & availability of trainer.

BESTWAY TECHNOLOGIES offering online training with flexible & cost effective.  Attend INFORMATICA  classes in online no need to come to my place attend INFORMATICA classes at your place anywhere world any time zone. Our participants students will be eligible to clear all type of any interviews at end of our INFORMATICA sessions.  My INFORMATICA trainer will give future help and assistance in subject for participants. We provide you with 24/7 server access for practicing. Please call : 91-9000567126 ( WhatsApp) , Mail : bestwaytechnologies@gmail.com

 

INFORMATICA 9.X  COURSE CONTENTS

DATAWAREHOUSING CONCEPTS:

  •   Introduction to Data Warehousing
  •   What is Data warehouse?
  •   Components of Data warehouse
  •   OLTP Systems
  •   OLTP vs DATAWAREHOUSE (OLAP)
  •   ODS(Operational Data Store)
  •   OLAP,ROLAP,MOLA

 Data Modeling

  •   What is the use of data modeling in Data warehousing?
  •   Schema
  •   Star Schema
  •   Snowflake Schema
  •   Snowflake Schema(hybrid schema or galaxy schema)
  •   Fact Table and types
  •   Dimension Tables and different types of dimensions
  •   Multi dimension, Summary / Aggregations table

  Slowly Changing Dimensions(SCD)

  Introduction of Informatica power center

  •   ETL Architecture
  •   Data source
  •   Data targets
  •   Repository
  •   Meta data
  •   Server components
  •   Client components

  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
  •   Creating folder

  INFORMATICA DESIGNER

  •   Connecting to the designer
  •   Components of the designer
  •   Creating DSN(data source name)
  •   Accessing the source, definitions to the designer
  •   Warehouse Designer
  •   Creating the target Tables using warehouse
  •   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
  •   Reusable transformations Debugger
  •   Working with mapping using Debugger
  •   Variable and Parameters

WORKFLOW MANAGER

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

 WORKFLOW MANAGER

  •  Session logs
  •  Workflow logs

  ETL Performance Tuning

  Best Practices

 

  • Request Demo