Informatica 9.6.1 Online Training
Course Duration : 30 Hrs
Informatica Course Content
BASICS OF DATA WAREHOUSING
CHAPTER 1: INTRODUCTION TO DATA WAREHOUSING
- Data warehouse concept
- Differences between Online Transaction Processing and data warehouse
- Types of Data Warehouse
- Data warehouse Architecture
- Difference between Data warehouse & Data mart
- Data Warehouse Approaches
- Data Warehouse Components
- Logical & physical Design
- Operational data sources(ODS)
CHAPTER 2: MODELLING FOR DATA WAREHOUSE
- Fact Table
- Dimension tables and types
- Data Warehouse Schemas: Star schema and Star Query, star flake schema, snow flake schema and Galaxy Schema
INSTALLATION of INFORMATICA and CONFIGURATION
CHAPTER 1: TOOL KNOWLEDGE
- Informatica PowerCenter
- Product Overview
- PowerCenter Domain
- Administration Console
- PowerCenter Repository
- PowerCenter Client
- Repository Service
- INTEGRATION SERVICE
- WEB SERVICES HUB
CHAPTER 2: REPOSITORY MANAGER
- Adding a Repository to the Navigator
- Configuring a Domain Connection
- Connecting to a Repository
- Viewing Object Dependencies
- Validating Multiple Objects
- Comparing Repository Objects
- Working with Folders
CHAPTER 3: POWERCENTER DESIGNER
- Source Analyzer
- Working with Relational Sources
- Working with Flat Files
- Target Designer
- Mappings
- Transformations
- Working with Ports
- Using Default Values for Ports
- User-Defined Default Values
- Tracing Levels
- Basic First Mapping
- Expression Transformation
- Filter Transformation
- Router Transformation
- Union Transformation
- Sorter Transformation
- Rank Transformation
- Aggregator Transformation
- Joiner Transformation
- Source Qualifier
- Lookup Transformation
- Lookup Types
- Lookup Transformation Components
- Connected Lookup Transformation
- Unconnected Lookup Transformation
- Lookup Cache Types: Dynamic, Static, Persistent, Shared
- Update Strategy
- Dynamic Lookup Cache Use
- Lookup Query
- Lookup and Update Strategy Examples
- Stored Procedure Transformation
- Connected Stored Procedure Transformation
- Unconnected Stored Procedure Transformation
- Sequence Generator Transformation
- SCD Type 1 and Type 2 with real time examples
- Mapplets: Mapplet Input and Mapplet Output Transformations
- Normalizer Transformation
- XML Sources Import and usage
- Mapping Parameters and Variables
- Parameter File
- Indirect Flat File Loading
CHAPTER 4: WORKFLOW MANAGER
- Working with Workflows
- Assigning an Integration Service
- Working with Links
- Workflow Variables
- Session Parameters
- Working with Tasks
- Session Task
- Email Task
- Command Task
- Working with Event Tasks
- Timer Task
- Decision Task
- Control Task
- Assignment Task
- Schedulers
- Worklets
- Session Properties
- Workflow Properties
CHAPTER 5: ADVANCED TOPICS
- Push down Optimization Technique
- Unit Testing
- Version Control
- Constraint Based Load Ordering
- Target Load Plan Order