Informatica 8.6 Online Training: Fees Usd 250.00 Only

[learncognos]

[b] Informatica 8.6 ($$250) - April 21th 2012 - In DEPTH Online Training[/b]


[u][b]Decimal Solutions Inc is conducting “Informatica 8.6 Online” Training on April 21th 2012[/b][/u]

[b]DSI is a leader in Online and Classroom trainings and we are into consulting and placement services. Our teams of experts have more than 10 years of real time consulting experience in the relevant areas. Experienced consultants train and impart practical and theoretical knowledge. [/b]

Few of the features of our online training program are:

• Duration: Around 25 Hours of Intensive Training Sessions
• Real Time Instructor Led Live Online Training
• Convenience of learning anytime/ anyplace
• Practicals after every major topic
• Software Install for practice
• Tests and FAQs from interviews point of view with Project Work
• Mock Interviews after the completion of the Course


[b]Informatica 8.6 Online Training : Fees: 250 US Dollars[/b]
All Lab Exercises, Power Point materials, Guide and Softwares Provided

[b]Introduction to Data Warehousing[/b]
What is Data warehousing?
Who needs Data warehouse?
OLAP vs OLTP
Why Data warehouse is required?
Components of a Data warehouse
Understand Datwarehouse Schema- Star and Snowflake Schema

[b]Introduction to ETL[/b]
Components of ETL

[b]Power Center 8.6 Architecture and Components: [/b]
Introduction to Informatica Power Center (Data Integration)
Difference between Power Center and Power Mart
Power Center 8.x Architecture
Components of Power Center: Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager.

[b]Informatica 8.6 Power Center Web Administrator Console[/b]
Creating the Informatica Repository Server
Connecting the server
Creating Repository
Creating Integration Services

[b]Informatica 8.6 Repository Manager[/b]
Creating the Workspace (Folder)
Creating users
Creating user passwords
Creating user groups
Giving privileges to the users, user groups and folders

[b]Overview of Informatica 8.6 Installation[/b]
System Requirements
Database Installation and schema creation
Creating Domains and Configurations
Creating Repository
Create a Repository and Integration Service
Creating users and folders


[b]Informatica 8.6 Power Center Designer[/b]
Introduction to designer
Designer Interfaces
Designer tools
Connecting to Designer
Components of Designer
Creating Data Source Names
Accessing the source, definations to the designer
Defining Sources
Database as a source
Flat Files sources
Defining Targets
Working with Relational Targets
Working with Flat File Targets
Creating target database objects
Mapping designer
Mapping between the source and target tables
Transformation between source and target tables

[b]Informatica 8.6 Designer – Understand Transformations[/b]
What are “Informatica Transformations”
Active and Passive Transformations
Source Qualifier Transformation
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored Procedure Transformation
Mapplet Transformation
Union Transformation
Lookup Transformation: Connected and Unconnected
Reusable Transformations

[b]Understand SCD (Slowly Changing Dimensions) [/b]
Implement Type-I mappings
Implement Type-II mappings
Implement Type-III mappings

[b]Informatica 8.6 Workflow Manager[/b]
Define Informatica Workflow and why do we need them
How to create a Workflow
Components of a Workflow
Defining Tasks in Workflow
Create a Command Task
Create a Email Task
Create a Session Task and understand different settings
Configure Event Wait & Event Raise Task
Creating Connections
Start Workflow
Monitor Workflow
Understand Session logs
Understand Workflow Logs

[b]Workflow Scheduling: Scheduling Tools[/b]
Use Informatica Scheduler
Use 3rd party scheduling tools like Autosys

[b]Performance Tuning in Informatica[/b]
Why Performance Tuning
Identify Bottlenecks in Source
Identify Bottlenecks in Targets
Identify Bottlenecks in Transformations
Identify system bottlenecks in Windows
Optimizing strategies for Source, Targets, Mappings and Transformations
Performance of Lookups

[b]Command Line Interface used in Informatica[/b]
Overview of PMCMD and functions.
Overview of PMREP and functions.

[b]Informatica Backups and Deployments[/b]
Steps to perform the Repository and Database backups
Use Deployment Strategies- Import and Export of Sessions, Workflows, Mappings

[b]Informatica 8.6 Interview Questions[/b]
We will provide you bunch of “Most Commonly Asked” Informatica Interview Questions


[b]PROJECT [/b]

[b]We will be creating a Project and working on different Scenarios and implementing different transformations as given below. ALL OF THEM HAVE STEP BY STEP SCREENSHOTS [/b]

Exercise 1: Defining Sources & Targets.doc
Exercise 2: Creating a Mapping.doc
Exercise 3: Create & Run a Workflow.doc
Exercise 4: Features and Techniques I.doc
Exercise 5: Using the Debugger.doc
Exercise 6: Flat File Wizard and Filter Transformation.doc
Exercise 7: Heterogeneous Join, Aggregator, & Sorter.doc
Exercise 8: Basic Lookup.doc
Exercise 9: Deleting Rows.doc
Exercise 10: Data-Driven Operations.doc
Exercise 11: Incremental Update.doc
Exercise 12: Features and Techniques II.doc
Exercise 13: Router.doc
Exercise 14: Straight Load.doc
Exercise 15: Conditional Lookup.doc
Exercise 16: Heterogeneous Targets.doc
Exercise 17: Mapplets.doc
Exercise 18: Reusable Transformations.doc
Exercise 19: Command Task.doc
Exercise 20: Reusable Worklet & Decision Task.doc
Exercise 21: Event Wait with Pre-Defined Event.doc
Exercise 22: User-Defined Event, Event Raise, and Event Wait.doc


[b]PROJECT 2[/b]
We will also have an introduction to “COGNOS 8.4 BI REPORTING SUITE” and see how we can create sample reports from the target tables

What is Cognos 8.4 BI
Components of Cognos Reporting
Understand Framework Manager
Understand Reporting terminologies
Create Sample List and Crosstab Reports


[b]Contact: Please send a mail to: learncognos[img]http://www.eknazar.com/ekClassifieds/sbclassified_icons/em.gif[/img]aol.com[/b]


[b]Contact:[/b] Ramesh
[b]Phone:[/b] 6516494489