 |
|
1)
DW CONCEPTS
2)
INFORMATICA
3)
DAC
4)
OBIA
|
5)
LIVE PROJECTS
6)
SQL
7)
CHAPTER WISE PPTs
8)
CHAPTER WISE HANDSONS
9)
CHAPTER WISE RECORDINGS
|
Course
Duration: 60 Hrs & 45 Days
Training Mode: Class Room/On Line
Training Methodology: Real-time Project oriented.
Data Warehouse concepts
- What is data
- Types of Data
- Transactional Data
- Analytical Data
- Types of Data Bases
- Data Warehouse Architecture
- History of Data warehouse
- What is Data Warehouse
- What is Data Mart
- What is ETL
- Types of Tables
- Types of Schemas
- Star Schema
- Snow flake Schema
- Mixed Schema
INFORMATICA 9
- INFORMATICA 9 Introduction
- INFORMATICA 9 Installation
- Server Installation
- Client Installation
- Informatica Architecture
- Informatica different components
- Administration Console
- Repository Manager
- Designer
- Workflow Manager
- Workflow Monitor
1. Informatica
Administration Console
1.
Creating Repository service
2.
Creating Global Repository Service
3.
Creating Integration Service
4.
Creating Users
5.
Creating Groups .
6.
Creating Roles
7.
Assigning users to a group
8.
Assigning Privileges and Roles to a
Group.
2. Repository Manager
1.
Adding Repository
2.
Creating a Folder
3.
Creating Shared Folder
4.
Folder Permissions
3. Designer
- Configuring RRITEC Database
- Configuring source database
- Configuring Target database
- Hands on 01 Source Target Import
- Exercise 1: Import a Source Schema
- Exercise 2: Import a Target Schema
- Hands on 02 Creating mapping
- Exercise 1: Create a Mapping
- Hands on 03: Creating Workflow
- Exercise 1: Create a Workflow
- Exercise 2: Create source and target database connections
- Exercise 3: Create a Task and Run the Workflow
- Exercise 4: Monitor the Workflow
Transformations
- What is Transformation?
- Types of Transformations?
- Active and passive transformations
- Connected / Unconnected transformations
- Expression Transformation
- Filter Transformation
- Router Transformation
- Difference between Filter and Router
- Sorter Transformation
- Aggregator Transformation
- Sorted Input aggregation
- Unsorted input Aggregation
- Joins
- Homogeneous Join by Source Qualifier
- Heterogeneous Join by Joiner Transformation
- Master Outer Join
- Detail Outer Join
- Full Outer Join
- Source Qualifier Transformation
- SQL Override
- User defined join
- Source Filter
- Pre sql
- Post sql
- Lookup
- Connected Lookup
- Unconnected Lookup
- Static Cache
- Persistent Cache
- Dynamic Cache
- Lookup Policy
- Sequence Generator Transformation
- Generating Surrogate Key
- Replacing Missing Values
- Understanding Nextval & Currval ports
- Update Strategy Transformation
- Slowly Changing Dimension 1
- Slowly Changing Dimension 2
- Slowly Changing Dimension 3
- Incremental Loading
- Stored Procedure Transformation
- Connected Stored Proc
- Unconnected Stored Proc
- Rank Transformation
- Union Transformation
- XML Transformations
- Normalizer Transformation
- Transaction Controlled
- Java Transformation
- SQL Transformation
- Creating Mapplets
- Mapplet input transformation
- Mapplet output Transformation
- Using Mapplet in Mapping
- Reusable Transformations
- User Defined Functions
- Parameter &Variables
- Mapping level
- Mapplet Level
- Workflow Level
- Work let Level
- Service process variables
- Parameter file
- Target Load Plan
- Constraint Based Loading
4. Workflow Manager
- What is task ?
- Types of Tasks ?
- Session
- Command
- Decision
- Assignment task
- Event wait task
- Event raise task
- Timer task
- Assignment
- Worklet
- Control
- Creating parallel Tasks
- Creating Sequence tasks
- Session Properties
- Link task
- Configuring Database Connections in the Workflow Manager
- Creating a Reusable Session
- Creating a Workflow
- Running Workflows
- Scheduling workflow
- Creating Work let
- Using work let in workflow
- Opening the Workflow Monitor
- Post session and Pre-session commands
- Session recovery
- Commit points
5. Workflow Monitor
- Monitoring workflows
- Get run properties
- Observe workflow log
- Observe session log
- Session recovery
- Commit points
- PMCMD command
- PMREP Command
6. Debugger
1.
Creating a Debug Session
2.
Debugger windows and indicators
3.
Debugger functionality and options
4.
Viewing data with the Debugger
5.
Setting and using Breakpoints
- Tips for using the Debugger
7. Performance Tuning
- Target bottleneck
2.
Source bottleneck
3.
Mapping bottleneck
4.
Session bottleneck
5.
System bottleneck
8. Batch File
- What is Batch File
- Creating batch file
9. DAC
1. Configuring Data Base
2. Configuring Informatica
Integration Service
3. Configuring Informatica
repository Service
4. Configuring SDE and SIL mappings
5. Creating Task Phases
6. Creating primary source
7. Creating Target source
8. Creating logical Folder
9. Creating Physical Folder
10. Maping Logical and Physical
Folders
11. Creating Tasks
12. Creating Subject Areas
13. Creating
14. Scheduling Execution Plans
10. OBIA
1. Oracle Business Intelligence
Application Overview
2. Oracle Business Intelligence
Application Overview and Architecture
3. Oracle Business Analytics
Warehouse Content
4. Installing the Oracle Business
Analytics Warehouse Components
5. Understanding the ETL Process
6. Working with Informatica Designer
7. Exploring SDE and SIL Mappings
8. Building SDE and SIL Mappings
9. Working with Informatica Workflow
Manager
10. Working with Data Warehouse
Administration Console
11. Populating the Oracle Business
Analytics Warehouse
12. Configuring the Oracle Business
Analytics Warehouse
13. Customizing the Oracle Business
Analytics Warehouse
14. Working with oraclebianalytics
predefined RPD
15. Working with Predefined Reports
and dashboards
11. Live Project
1. Gathering Requirement
2. Understanding & Analyzing
Requirement
3. Developing Business Specification
Document
4. Developing High Level Design
Document
5. Developing Low level Design
Document
6. Following Unique Coding Standards
No comments:
Post a Comment