space
Search Courses  in 

Get CourseName COURSE FEES Instantly from BEST Training Institutes!

 

My City

I need details for

 

My Name

My Mobile Number

My Email ID

VENTOSOFT Chennai Thousand Lights - DATAWAREHOUSING TRAINING IN CHENNAI AT VENTOSOFT

 

Information


INFORMATICA 8.X COURSE CONTENT
Table of Contents

1 DURATION 2
2 PRE-REQUISITES 2
3 TOPICS 2
3.1 INTRODUCTION AND ARCHITECTURAL OVERVIEW 2
3.2 REPOSITORY MANAGEMENT 2
3.3 INFORMATICA TOOLS 3
3.4 INFORMATICA OBJECTS 3
3.5 OTHER CONCEPTS 4
3.6 PERFORMANCE AND ADMINISTRATION 4
3.7 DW CONCEPTS 5


DURATION
30 Days
1 PRE-REQUISITES
- Basic RDBMS knowledge and application
- Data Warehousing Basics Knowledge
- Prior Experience of Informatica - not required
2 TOPICS
2.1 INTRODUCTION AND ARCHITECTURAL OVERVIEW
a. Introduction to Service Oriented Architecture
b. What’s new in Infa 8
c. Informatica 8 architecture
d. Installation and Configuration
e. Integration Service
o Configuration
o Start/Stop
o Basic Administration
f. Repository Service
o Configuration
o Start/Stop
o Basic Administration
g. Admin Console
o Usage
o Properties
h. Domain / Node Basics
2.2 REPOSITORY MANAGEMENT
a. Repo service
b. Maintenance
c. Folder & Security Concepts
o Shared/Non-shared
o Group/User/Permissions

INFORMATICA TOOLS
a. List of tools
o Development tools
 Explain each tool with its features
o Admin tools
 Explain each tool with its features
2.3 INFORMATICA OBJECTS
a. Sources & Targets
o Types of sources/targets
o Creation and configuration using Developer
o Relational
o Flat File (Fixed / De-limited)
o XML
o Mainframe – VSAM / PowerExchange

b. Transformations
o Transformation types
o Transformation features
o Creation and Basic configuration
o Advanced Properties
o Active / Passive difference
o Cover all transformations
o Cache
 Basics
 Types
 Usage in transformations
 Properties
o Run-time properties
o Ports
 Usage
o Parameters and Variables
 Usage
o Transformation rules
o Reusable transformations – rules and how to create
o Coding Standards

c. Mapping & Mapplets
o Creation
o Definition
o Mapplets – rules and how to create and use
o Validation
o Coding Standards

d. Tasks
o Types of tasks
o Properties and configuration
o Re-usable and non re-usable tasks
o Coding Standards

e. Workflows and Worklets
o Creation and configuration
o Connections and Links
o Worklets – rules and how to create and use
o Coding Standards
2.4 OTHER CONCEPTS
a. Versioning
o What is versioning
o How it is available in Informatica
o Usage
b. Deployment
o What is deployment
o Deployment groups
o Creation and configuration
o Label creation and usage
o Migration from one environment to another
c. Partitioning
o What is partitioning
o Dynamic partitioning
o Rules of partitioning for each transformation
o Partitioning in action
d. XML/ UDO / Web Services
o Basics
o Usage and configuration
3.6 PERFORMANCE AND ADMINISTRATION
a. Workflow Monitoring
o Workflow Monitor views
o Monitoring a Server
o Actions initiated from the Workflow Monitor
o Filtering views
b. Performance Tuning
o Bottlenecks
o Configuring Properties of Info objects for Performance Tuning
o DTM – basics
o Threads – basics
c. Monitoring
o Monitoring workflows
o Different Views
e. Debugging
o Ways and approach to debug issues
o Using Debugger Tool
o Test data Load
o Different log files generated
o How to interpret messages in Log File
o Tracing Levels
o Query Tuning
o
d. Repository
o Backup and Restoration
o Code Pages and Character Sets

2.5 DW CONCEPTS
a. SCD
o Types of SCD
o Implementing SCD Types using Informatica

 

Course Information

DATA WAREHOUSING : ETL AND REPORTING

 

Contact Information

Address: VENTOSOFT Chennai,
7E, 7th Floor, PM Towers, Greams Road,
Mount Road, Chennai-600006. , Chennai , Greams Road
Prolific Training India Plc Training

 

Training course fee & Discounts