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
- 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
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
- Session logs
- Workflow logs
