Informatica

Data Warehousing Concepts:

• What is Data warehousing?
• Ralf Kimbol Definition
• Bill Inmon Definition
• Types of Systems

• OLTP
• OLAP

• Difference Between OLTP, OLAP
• Drawbacks of OLTP
• Data warehousing Project Life Cycle
• Data Warehousing Project Implementation Approaches

Data warehousing Architecture:

• Source
• Staging Area
• Targets
• Data Marts
• ODS
• EDW

Data Modeling:

• Conceptual Data Modeling
• Logical Data Modeling
• Physical Data Modeling

Dimensional Modeling:

• What is a Dimension?
• Types of Dimensions
• What are Facts?
• Types  of Facts
• Cubes
• Hierarchies
• OLAP Types (MOLAP,ROLAP,HOLAP)
• Star Schema
• Snow Flake Schema

Informatica 9x:

• Installation/Configuration
• Informatica Architecture
• Tools and their roles
• Repository Service
• Integration Service
• DTM Process
• Informatica Administration Console
• Environment Setup
• Differences between 7x, 8x & 9x

Designer:

• Designer tools
• Defining Sources
• Database as a source
• Flat Files sources
• XML Sources

• Defining Targets

• Importing from database
• Creating a new target

• ETL Process in Informatica

• Source Analyzer
• Target Designer
• Mapping Designer
• Task Developer
• Workflow Designer

• Transformations (Active, Passive)
• Transformations (Connected/Unconnected)
• Cache
• Source Qualifier

• SQL Override
• Filtering Data
• Sorting Data
• Joining Sources

• Filter
• Expression

• Data Cleansing
• Data Scrubbing

• Sorter
• Sequence Generator

• Replacing Missing Values

• Rank
• Aggregator

• Incremental Aggregation

• Router

• Diff Between Router/Filter

• Joiner
• Union
• Lookup

• Connected
• Un Connected
• Cache

• Stored Procedure

• Connected
• Un Connected

• Update Strategy
• Transaction Control
• Normalizer
• SQL
• XML

Workflow Manager

• Relational Connections
• Re Usable Tasks

• Session
• Command
• E-Mail

• Non Re Usable Tasks

• Session
• Command
• E-Mail
• Event Raise
• Event Wait
• Decision
• Timer
• Control
• Assignment
• Link

• Session properties
• Creating Workflow
• Starting Workflow
• Monitoring Workflow

Advanced Features

• Constraint Based Loading
• Target Load Plan
• Mapplet  Creation & Implementation
• Mapping Parameters
• Mapping Variables
• Session Parameters
• Flat Files

• Fixed Width
• Delimited
• File Repository

• Business Components
• User Defined Functions
• Debugger
• Version Control
• Push Down Optimization
• Performance Tuning

Informatica Administration Console:

• Creating Repository Service
• Creating Integration Service
• Creating Users
• Creating Groups
• Creating Roles
• Assigning Users to Groups
• Assigning Roles to Groups