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

DATAWAREHOUSING TRAINING IN CHENNAI AT VENTOSOFT by VENTOSOFT Chennai at Thousand Lights

 

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
TrainerDesk Training Jobs

 

Training course fee & Discounts