Informatica
Course
In Hyderabad
₹ 1
VAT incl.
Description
-
Type
Course
-
Location
Hyderabad
-
Class hours
35h
Facilities
Location
Start date
Hyderabad
(Andhra Pradesh)
See map
516,Annapurna Block, AdityaEnclave, Ameerpet, Hyderabad-500026, 500026
Start date
On request
Reviews
Have you taken this course?
Course programme
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
Informatica
₹ 1
VAT incl.