 |
|
|
|
|
|
|
Classifieds: Education / Training | | Informatica and Cognos Online Training | | Posted By: Ramesh Vella at: 10, Aug 2014 11:37:00 PM IST | Blue Raay IT Solutions Inc is conducting '' Cognos 10.1 Business Intelligence and “Informatica 9.1 Online” Training August 2014
BRIS 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.
We also provide Placement and Sponsorship assistance also
• Around 30 Hours of Intensive Training Sessions
• Real Time Instructor Led Live Online Training
• Convenience of learning anytime/ anyplace
• Practicals after every major topic
• Tests and FAQs from interviews point of view with Project Work
• Mock Interviews after the completion of the Course
Informatica 9.1 Online Training : Fees: 300 US Dollars
All Lab Exercises, Power Point materials, Guides Provided
Introduction to Data Warehousing
What is Data warehousing?
OLAP vs OLTP
Components of a Data warehouse
Understand Datwarehouse Schema- Star and Snowflake Schema
Introduction to ETL
Power Center 9.1 Architecture and Components:
Introduction to Informatica Power Center and Architecture(Data Integration)
Difference between Power Center and Power Mart
Components of Power Center: Power Center tools: Designer, Workflow manager, Workflow Monitor, Repository Manager.
Informatica 9.x Power Center Web Administrator Console
Creating the Informatica Repository Server
Connecting the server
Creating Repository
Creating Integration Services
Informatica 9.x Repository Manager
Creating the Workspace (Folder)
Creating users, passwords, groups
Giving privileges to the users, user groups and folders
Overview of Informatica 9.1 Installation
Database Installation and schema creation
Creating Domains and Configurations
Creating Repository
Create a Repository and Integration Service
Creating users and folders
Informatica 9.1 Power Center Designer
Introduction to designer
Designer Interfaces
Designer tools
Connecting to 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
Informatica 9.1 Designer – Understand Transformations
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
Understand SCD (Slowly Changing Dimensions)
Implement Type-I, Type-II and Type-III mappings
Informatica 9.0 Workflow Manager
Define Informatica Workflow and why do we need them
How to create 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
Workflow Scheduling: Scheduling Tools
Use Informatica Scheduler and 3rd party scheduling tools like Autosys
Performance Tuning in Informatica
Identify Bottlenecks in Source, Targets, Transformations
Identify system bottlenecks in Windows
Optimizing strategies for Source, Targets, Mappings and Transformations
Command Line Interface used in Informatica
Overview of PMCMD and PMREP functions.
Informatica Backups and Deployments
Steps to perform the Repository and Database backups
Use Deployment Strategies- Import and Export of Sessions, Workflows, Mappings
Informatica 9.1 Interview Questions
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
Advanced Topics in Informatica 9.1
Target Load Plan
Incremental Loading
Incremental Aggregation
Indirect File List
Implement Row Error Logging
Understand Mapping Parameters and Variables
Versioning Control in Informatica
Cognos 10.1 Business Intelligence Course Curriculum Fees 350.00
Cognos 10 new features
Dashboard (Business Insight)
Create New Dashboard and add Reports
Creation of Select Value Filter
Creation Of Slider Filter
Insert Text into Dashboard
How to insert My inbox into Dash Board
How to Edit Dashboard Style
How to edit source report from Dashboard
Cognos Connection
Examine Cognos Connection
Creation of data Source connection at Cognos connection level
Creation Of Report Shortcut, Jobs
Scheduling Reports, Report shortcut, Jobs
Disabling Schedule
Organize content with folders and shortcuts
Personalize Cognos Connection
How to add portal tab
Create Users Groups and Users Roles
Adding Users to Users Groups
Importing and Exporting Reports From one Environment to Another Environment (Development Environment to production Environment)
Working with Cognos 10 My Inbox
Creation of new tasks
Creation of new notifications
How to Change Owner
View comments
Complete Task
How to change Status of a task
How to Change Priority of a task
Cancel Tasks
Business Insight Advanced
Create report using my business insight advance
Apply calculations
Create calculated columns
Add context filter
How use page layer and Prompt
Query Studio
Creation Of List Report
Converting List to Crosstab
Converting List to Chart
Interface Formatting
Creation of Calculated Column
Sectioning
Creation of Custom Group
Report Definition
Conditional Formatting
Filter grouping
Prompts
Page brakes
Suppress null values
Run and Manage Reports
Apply template to Query studio report
Drill down and drill up
How to apply Drill through
Report Studio
Introduction to Report Studio
Report Studio User Interface
Creating, Save and Run Reports
Report Templates
Managing Reports
Types of Reports
List Reports
Crosstab Reports
Charts
Active form report
Formatting a Report
Report Layout Guidelines
Fonts, Styles, Header, Footer and Borders
Insert objects
Apply Table Styles
Swap Columns and Rows
Working with Data
Filters, Parameters and Prompts
Detail Filter & Summary Filter
Context filter
Context prompt
Slicer
Creation of single select cascading prompt
Creation of multi select cascading prompt
Context filter and context prompt
Sorting and Grouping
Subtotals and Calculations
Working with Reports
Conditional Formatting
Conditional style
Style variables
Render variable
Drill-through Reports
Master-Detail Reports
Creation Of different type of variable
How to apply Page brakes in Report Studio
Report Template
How to create Report Template
How to apply RS Template to Qs report and Rs Report
How to convert Report to Template
Manage External Data
Active Report
How to convert report to active report
How to use data tab control
How to use tab control
How to use button bar
How to use data button bar
Analysis Studio
About Analysis studio
Creation Crosstab
Nested Crosstab Creation
How to create Context filter
Add Filter on Rows and columns
How to create combined filter
How to display excluded item total in report
Create Calculated Column
How to change Column name
Create Custom set
Create Chart
Drill Down and drill up
Context filter
How to add header to report
How to apply page brakes
How to apply template
How to display cube updated date in header
Framework Manager
Creation of Project
Creation of data source connection
Import data From Database
Creation of Namespace, Folder ,Short cut to the Query subject
Joins and cardinality
Query subjects
Data source query subject
Model query subject
Stored procedure Query subject
Calculation
Embedded calculation
Standalone calculation
Filters
Embedded Filters
Standalone Filters
Query Set
Changing Query usage item properties
Regular and Measure Dimensions
Scope Defining
How to change usage property for Query item
Securities
Objective level
Data Level
Package level
Edit Governors
Update and Merge Query subject
Creation Of package, versions and Publish
Transformer
What is Cognos Transformer
Understanding Power Play Data Sources
Starting and Navigating Transformer
Creating your Power Cube
Building the Time Dimension
Create New Dimensions from Source Data
Adding Cube Password Protection
Creating Regional Power Cubes
Creating Special Categories
Creating Calculated Columns
For Immediate attention please contact Ramesh 6516494489
|
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
