Informatica - Data WareHouse Course

Training/Coaching/Tuition by Sudeep Technologies Hyderabad View Contact

Request Info

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 warehousing for OLTP systems

• Dependent Data warehouse

• Independent Data warehouse

• Meta data and Data Mining

• OLAP, ROLAP, MOLA

• Data cleansing

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:

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

Informatica 8.6

• Introduction of Informatica power centre

• ETL Architecture

• Data source

• Data targets

• Meta data

• Repository

• Client components

• Server components

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

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

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

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

Workflow Manager:

• Components of workflow manager

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

Sudeep Technologies

SUDEEP TECHNOLOGIES was established with an aspect of providing comprehensive end to end training on various computer software IT courses. Our team consists of high end professionals with vast real time experience who trains you on all courses to bridge the gap between industry and academic graduates.

we provide cost effective training for needy learners with utmost care and guidance according to the demand of job market. Faculty, technically sound in high end technologies will teach you with quality principles and deliver the methodology of easy learning which gets you updated to the current trend. Sudeep Technologies, with dedication provides you the best learning concepts which puts you front in this competitive software world as a successful one.

Our faculty are enough skilled to explore the complicated concepts and explains you in a well descriptive manner.As the pace of technological enhancements is getting faster day by day there is indispensable part of imparting advance concepts to the learners to meet the demand which is the cause for emerge of SUDEEP TECHNOLOGIES.

We are ideal for beginners and an added advantage to the professionals to enhance their skills as we deals in depth with the advance concepts of the courses and also provide implementation-real time concepts. SUDEEP TECHNOLOGIES, renders one to one online training for students in state-of-the-art technology platforms in India or abroad.we save your time and money by avoiding expensive travel through online training. With the latest in collaborative technology, top instructors, cutting-edge curriculum we provide an exciting combination of traditional content and interactive learning and also materials with rich information that shouldn’t make any difference to the class room training.

Personalized online training sessions can be held comfortable to the student ease.without any hesitation, we offer you a100% student satisfaction online program.If you have any queries please contact us through e-mail id or phone or fill the enquiry form with the necessary details.