INFORMATICA COURSE CONTENT -
Introduction
- Overview
- Basic Definitions
- Informatica products
- Informatica Architecture
- Tools and their roles
- Folders-Sub folders
- Power center / Power mart
Infomatica
Designer - Introductiion
- Introduction to Designer
- Logon to Designer
- Designer interfaces
- Designer Tools
- Defining Sources
- Database as a source
- Flat File sources
- Defining Targets
- Importing from database
- Creating a new target
- Creating target database objects
Informatica Designer
- Mapping Introduction
- Source Qualifier
- Ports
- Mapping - Table to Table
- Mapping Flat File to Table
- Connected /Unconnected Transformations
- Active and Passive Transformations
- Source Qualifier to join Data
- Filter Transformation
- Expression Transformation
- Sequence Generator Transformation
- Rank Transformation
- Router Transformation
- Aggregator Transformation
- Joiner Transformation
- Stored Procedure Transformation(Connected and Unconnected)
- Union Transformation
- XML Transformation
- Mapping Wizards
- Implementing Type-I,Type-II,Type-III Mappings
Informatica
- Workflow Manager
- Workflow Introduction
- Tasks
- Workflow tools
- Connetions
- Defining tasks
- Command Tasks
- Email Task
- Session Task
- Link Conditions
- Event Wait & Event Raise
- Setting Properties of Session Task
- Creating Workflow
- Starting Workflow
- Monitoring Workflow
Informatica
Advanced Features
- Incremental Aggregation
- Mapplet Implementation
- Target Load Plan
- Constraint Based Loading
- Mapping Variable
- Session Parameters
- Link Conditions
- Reusable Transformation
- Task and Types of Tasks
- Work let and Types of work lets
- Scheduling Workflow
- Control flow using Command task and event wait task
- Incremental Loading
0 comments:
Post a Comment