monstercourses.com provides online training on all IT major technologies by industry it experts on dataware housing, sap , oracle, java, microsoft technologies, testing tools etc.
Wednesday, October 26, 2011
Tuesday, October 11, 2011
Cognos online training
COGNOS
COGNOS
COURSE DURATION : 30 HOURS
Introduction To Dataware Housing (Dwh)
- Introduction to DWH
- Characteristics of DWH
- OLTP Vs OLAP Databases
- Different Approaches of DWH (Kimball Vs Inmon)
- Data mart Vs Data Warehouse
- Fact Table Vs Dimension Table
- Concepts of Schemas (Star schema & Snowflake schema)
- Industry leading ETL and Reporting tools
- About Cognos 8.4
- 3 – Tier Architecture
- Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3) and their differences
- Features of Cognos 8.4
- Cognos Vs other OLAP tools
- Cognos components (Modeling & Reporting)
- Different cognos services
- Personalize cognos connection
- Create and manage portals, shortcuts, report views..etc
- Working with Cognos configuration, content Store
- How to Connect to different Data Sources
- Security setup
- Import and Export of Package (Deployment)
- Running the Report Burn
- Scheduling Reports
- About Framework Manager
- Framework Manager, Metadata Modeling
- Creation of Interface and Usage
- Creating Model & Namespace (Layers)
- Importing Metadata
- Naming convention for objects in a project
- Creating Query Subjects & Query Items
- Merging Query Subjects
- Creating Relationships & Setting Cardinalities
- Creating Parameter Maps & Macros
- Creating of Model Filters, Prompts & Calculations
- Add Business Rules and Set Governors
- Assigning package level security
- Improving performance
- Publishing Package
- Introduction
- About Ad-hoc Reports
- Types of Report(List, Cross Tab, Chart Reports & Others)
- Applying Filters, Prompts & Calculations
- Sorting, Grouping, Sections & Aggregate Functions
- Run and Manage reports
- Type of Report Templates
- Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
- Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
- Generating and Creating Prompt Page
- Types of Prompts
- Query Calculations & Layout Calculations
- Filters and Dynamic Filters
- Conditional Block
- Conditional Formatting
- Master Details
- Cascading Prompt
- HTML Items & Hyperlinks
- Set Operators
- Setting Burst Options
- Drill through
- Drill up & Drill down
- Setting Variables
- Report Functions
- Report Validation
- Reports Run with Options
- Insert Data
- Change the number of Visible Items
- Nest Data
- Replace Data
- Sort Data
- Explore Data
- Change the measure
- Drill down for Details
- Hide Items
- Insert a calculation
- Save a custom set
- Define a filter
- Compare sets of data
- Using Dynamic Context
- Creating Agents
- Adding Event conditions
- Task and Task execution rules
- Scheduling Agent.
Tuesday, October 4, 2011
Home
Benefits of online courses learning:
In traditional classrooms you will get
to listen the lecture only once but here you can rewind it and see till
the time you understands it.
Timing schedule to study Online courses
You can learn whenever you like. You can learn for 60 mins to 1 1/2 hrs on a day. Since the materials are available 24x7x360 days, you don’t have to wait for the instructors to come as you do in the traditional classrooms.
You can learn whenever you like. You can learn for 60 mins to 1 1/2 hrs on a day. Since the materials are available 24x7x360 days, you don’t have to wait for the instructors to come as you do in the traditional classrooms.
Online courses educational and professional background
You get to meet people from different part of the world with different educational & professional background. For instance you will get the chance to meet people working for WIPROs, Infosys, IBMs and people from US, Canada, UK etc.
You get to meet people from different part of the world with different educational & professional background. For instance you will get the chance to meet people working for WIPROs, Infosys, IBMs and people from US, Canada, UK etc.
Queries in Online courses
If you have a doubt you can reach out to all your classmates and the instructors by sending a single message. Our Support team available at 24/7.
If you have a doubt you can reach out to all your classmates and the instructors by sending a single message. Our Support team available at 24/7.
Save Money in studying Online courses
The best part is you can save lot of time and money. You can learn it from where ever you like. Need not to travel to the institution you can sit at home and learn.
The best part is you can save lot of time and money. You can learn it from where ever you like. Need not to travel to the institution you can sit at home and learn.
Survey report:Online courses vs Traditional learning
Recently US Department of Education has come up with a survey in comparison with online and traditional learning. Students in online courses learn more than those in traditional college classrooms, according to researchers.
Recently US Department of Education has come up with a survey in comparison with online and traditional learning. Students in online courses learn more than those in traditional college classrooms, according to researchers.
Informatica
Informatica Powercenter Course Outline
Some of the highlights of Informatica:- Informatica grew 18% for 5 years in a row.
- Informatica CEO- Sohaib reviewed 5 trends that are change people to focus beyond the data warehouse; Globalization, Consolidation, Growth, Operational Efficiency, and Governance.
- the demand for cloud solutions will continue to grow. Cloud and on-premise tools will exist and work together and Informatica will provide tools to control to manage both.
- Informatica now has a community site with an IdeaExchange just like D&B360 Ideas. It’s actually the same Salesforce.com tool we use at D&B.
- Informatica showed a new marketplace which was referred to as the Informatica cloud mall. Similar to AppExchange from SFDC but different. They have these things called Blocks. A block is nothing more than a page or a place holder. Using blocks Informatica can promote solutions built by Informatica Partners. Users can search, download, and purchase apps or add-ons.
Introduction and Architecture
- 1.1 Architecture and Software Overview
- 1.2 ETL and ELT Architecture Overview
- 1.3 Partitioning and Parallelism Introduction
- 1.4 PowerCenter Services RAM Utilization
- 1.5 Differences Between 32 bit and 64 bit
- 2.1 Introduction to Designer Interface
- 2.2 Introduction to Workflow Manager Interface
- 2.3 Introduction to Workflow Monitor
- 2.4 Introduction to Repository Manager
- 2.5 Nature of ODBC in the Designer
- 2.6 Software Demonstration
- 3.1 Flat File Sources
- 3.2 Relational Sources
- 3.3 Data Previewer
- 3.4 Metadata Extensions
- 3.5 LAB: Import a Source
- 4.1 Target Definitions
- 4.2 Target Properties
- 4.3 Flat File Targets
- 4.4 Relational Targets
- 4.5 LAB: Import a Target
- 5.1 Defining a Data Flow Diagram
- 5.2 Transformation Objects and Views
- 5.3 Source Definition and Source Qualifier
- 5.4 Pre-SQL and Post-SQL Rules
- 5.5 Expression Transformation
- 5.6 Informatica Functions
- 5.7 Variable Ports
- 5.8 Data Types
- 5.9 Mapping Validation
- 5.10 LAB: Create a Working Mapping
- 6.1 Workflow Tools
- 6.2 Workflow Structure
- 6.3 Workflow Connections
- 6.4 Workflow Tasks
- 6.5 Workflow Design Process
- 6.6 Workflow Properties
- 6.7 Workflow Links
- 6.8 Session Tasks
- 6.9 LAB: Configure a Workflow and Session
- 7.1 Workflow Monitor Views
- 7.2 Monitoring a Server
- 7.3 Actions Initiated from the Workflow Monitor
- 7.4 Filtering Views
- 7.5 Truncating Monitor Logs
- 7.6 Stop Versus Abort
- 7.7 LAB: Run and Monitor the Workflow
- 7.8 LAB: Demonstration of Designer Features
- 8.1 Debugger Features
- 8.2 Debugger Windows and Indicators
- 8.3 Debugger Best Practices
- 8.4 LAB: Debug the Mapping
- 9.1 Filter Functionality
- 9.2 Filter Properties
- 9.3 Filter Versus DB Where Clause
- 9.4 LAB: Create a Filter Transformation, Run Workflow
- 10.1 Sorter Functionality
- 10.2 Sorter Properties
- 10.3 Sorter Versus Database Order by Clause
- 11.1 Aggregator Transformation
- 11.2 Aggregator Expressions and Functions
- 11.3 Using Unsorted and Sorted Data
- 11.4 Data Flow Rules
- 11.5 Aggregator Versus Database Group By
- 12.1 Homogeneous and Heterogeneous Joins
- 12.2 Joiner Conditions and Properties
- 12.3 Joiner Usage
- 12.4 Nested Joins
- 12.5 Joiner Versus Database Join
- 12.6 LAB: Add Sorter, Joiner, and Aggregator
- 13.1 Lookup Principles
- 13.2 Lookup Properties
- 13.3 Lookup Caching
- 13.4 Lookup Versus Database Join
- 13.5 LAB: Create a Basic Lookup
- 14.1 Target Properties
- 14.2 WHERE Clause
- 14.3 Constraint-Based Loading
- 14.4 Target SQL Override Best Practices
- 15.1 Update Strategy Transformation
- 15.2 Update Strategy Expressions
- 15.3 Update Strategy Best Practices
- 15.4 LAB: Create a Type 2 Dimension Update
- 16.1 Router Functionality
- 16.2 Router Groups
- 16.3 LAB: Use a Router to Delete Rows
- 16.4 LAB: Data Driven Versus Session Switches
- 17.1 Parameter Scoping
- 17.2 System Variables
- 17.3 Mapping Parameters and Variables
- 17.4 Variable Functions
- 18.1 Usage and Techniques
- 18.2 Advantages
- 18.3 Functionality
- 18.4 Conditional Lookups
- 18.5 LAB: Create an Unconnected Lookup
- 19.1 Heterogeneous Target Types
- 19.2 Target Type Limitations and Conversions
- 19.3 LAB: Build Heterogeneous Targets
- 20.1 Mapplet Designer
- 20.2 Mapplet Advantages
- 20.3 Mapplet Types and Rules
- 20.4 Active and Passive Mapplets
- 20.5 Mapplet Parameters and Variables
- 20.6 Mapplet Designer Best Practices
- 20.7 LAB: Build a Mapplet
- 21.1 Transformation Developer
- 21.2 Rules
- 21.3 Promoting and Copying Transformations
- 21.4 Transformation Developer Best Practices
- 21.5 LAB: Create and Use a Reusable Transformation
- 22.1 Sequence Generator Functionality
- 22.2 Sequence Generator Properties
- 22.3 Sequence Generator Best Practices
- 22.4 LAB: Create a Variable Based Sequence Generator
- 23.1 Setting On and Off
- 23.2 Data Rejects with Error Logging Off
- 23.3 Error Logging to Database Table and Flat File
- 23.4 Source Row Logging
- 23.5 Error Logging Best Practice Architecture
- 24.1 Server Connections
- 24.2 Reusable Workflow Schedules
- 24.3 Reusable Session Configurations
- 24.4 LAB: Create a Sequential Workflow
- 24.5 LAB: Create a Concurrent Workflow
- 25.1 The Command Task
- 25.2 The Email Task
- 25.3 Reusable Task Best Practices
- 26.1 The Decision Task
- 26.2 The Assignment Task
- 26.3 The Timer Task
- 26.4 The Control Task
- 26.5 The Event Wait Task
- 26.6 The Event Raise Task
- 26.7 Non-Reusable Tasks Best Practices
- 26.8 LAB: Create Event Wait/Event Raise and Timer
- 26.9 LAB: Create a Control and Assignment Task
- 26.10 LAB: Create a Command Line Task
- 27.1 Reusable Worklet
- 27.2 Non-Reusable Worklet
- 27.3 Worklet Best Practices
Informatica
Informatica Powercenter Course Outline
Some of the highlights of Informatica:- Informatica grew 18% for 5 years in a row.
- Informatica CEO- Sohaib reviewed 5 trends that are change people to focus beyond the data warehouse; Globalization, Consolidation, Growth, Operational Efficiency, and Governance.
- the demand for cloud solutions will continue to grow. Cloud and on-premise tools will exist and work together and Informatica will provide tools to control to manage both.
- Informatica now has a community site with an IdeaExchange just like D&B360 Ideas. It’s actually the same Salesforce.com tool we use at D&B.
- Informatica showed a new marketplace which was referred to as the Informatica cloud mall. Similar to AppExchange from SFDC but different. They have these things called Blocks. A block is nothing more than a page or a place holder. Using blocks Informatica can promote solutions built by Informatica Partners. Users can search, download, and purchase apps or add-ons.
Introduction and Architecture
- 1.1 Architecture and Software Overview
- 1.2 ETL and ELT Architecture Overview
- 1.3 Partitioning and Parallelism Introduction
- 1.4 PowerCenter Services RAM Utilization
- 1.5 Differences Between 32 bit and 64 bit
- 2.1 Introduction to Designer Interface
- 2.2 Introduction to Workflow Manager Interface
- 2.3 Introduction to Workflow Monitor
- 2.4 Introduction to Repository Manager
- 2.5 Nature of ODBC in the Designer
- 2.6 Software Demonstration
- 3.1 Flat File Sources
- 3.2 Relational Sources
- 3.3 Data Previewer
- 3.4 Metadata Extensions
- 3.5 LAB: Import a Source
- 4.1 Target Definitions
- 4.2 Target Properties
- 4.3 Flat File Targets
- 4.4 Relational Targets
- 4.5 LAB: Import a Target
- 5.1 Defining a Data Flow Diagram
- 5.2 Transformation Objects and Views
- 5.3 Source Definition and Source Qualifier
- 5.4 Pre-SQL and Post-SQL Rules
- 5.5 Expression Transformation
- 5.6 Informatica Functions
- 5.7 Variable Ports
- 5.8 Data Types
- 5.9 Mapping Validation
- 5.10 LAB: Create a Working Mapping
- 6.1 Workflow Tools
- 6.2 Workflow Structure
- 6.3 Workflow Connections
- 6.4 Workflow Tasks
- 6.5 Workflow Design Process
- 6.6 Workflow Properties
- 6.7 Workflow Links
- 6.8 Session Tasks
- 6.9 LAB: Configure a Workflow and Session
- 7.1 Workflow Monitor Views
- 7.2 Monitoring a Server
- 7.3 Actions Initiated from the Workflow Monitor
- 7.4 Filtering Views
- 7.5 Truncating Monitor Logs
- 7.6 Stop Versus Abort
- 7.7 LAB: Run and Monitor the Workflow
- 7.8 LAB: Demonstration of Designer Features
- 8.1 Debugger Features
- 8.2 Debugger Windows and Indicators
- 8.3 Debugger Best Practices
- 8.4 LAB: Debug the Mapping
- 9.1 Filter Functionality
- 9.2 Filter Properties
- 9.3 Filter Versus DB Where Clause
- 9.4 LAB: Create a Filter Transformation, Run Workflow
- 10.1 Sorter Functionality
- 10.2 Sorter Properties
- 10.3 Sorter Versus Database Order by Clause
- 11.1 Aggregator Transformation
- 11.2 Aggregator Expressions and Functions
- 11.3 Using Unsorted and Sorted Data
- 11.4 Data Flow Rules
- 11.5 Aggregator Versus Database Group By
- 12.1 Homogeneous and Heterogeneous Joins
- 12.2 Joiner Conditions and Properties
- 12.3 Joiner Usage
- 12.4 Nested Joins
- 12.5 Joiner Versus Database Join
- 12.6 LAB: Add Sorter, Joiner, and Aggregator
- 13.1 Lookup Principles
- 13.2 Lookup Properties
- 13.3 Lookup Caching
- 13.4 Lookup Versus Database Join
- 13.5 LAB: Create a Basic Lookup
- 14.1 Target Properties
- 14.2 WHERE Clause
- 14.3 Constraint-Based Loading
- 14.4 Target SQL Override Best Practices
- 15.1 Update Strategy Transformation
- 15.2 Update Strategy Expressions
- 15.3 Update Strategy Best Practices
- 15.4 LAB: Create a Type 2 Dimension Update
- 16.1 Router Functionality
- 16.2 Router Groups
- 16.3 LAB: Use a Router to Delete Rows
- 16.4 LAB: Data Driven Versus Session Switches
- 17.1 Parameter Scoping
- 17.2 System Variables
- 17.3 Mapping Parameters and Variables
- 17.4 Variable Functions
- 18.1 Usage and Techniques
- 18.2 Advantages
- 18.3 Functionality
- 18.4 Conditional Lookups
- 18.5 LAB: Create an Unconnected Lookup
- 19.1 Heterogeneous Target Types
- 19.2 Target Type Limitations and Conversions
- 19.3 LAB: Build Heterogeneous Targets
- 20.1 Mapplet Designer
- 20.2 Mapplet Advantages
- 20.3 Mapplet Types and Rules
- 20.4 Active and Passive Mapplets
- 20.5 Mapplet Parameters and Variables
- 20.6 Mapplet Designer Best Practices
- 20.7 LAB: Build a Mapplet
- 21.1 Transformation Developer
- 21.2 Rules
- 21.3 Promoting and Copying Transformations
- 21.4 Transformation Developer Best Practices
- 21.5 LAB: Create and Use a Reusable Transformation
- 22.1 Sequence Generator Functionality
- 22.2 Sequence Generator Properties
- 22.3 Sequence Generator Best Practices
- 22.4 LAB: Create a Variable Based Sequence Generator
- 23.1 Setting On and Off
- 23.2 Data Rejects with Error Logging Off
- 23.3 Error Logging to Database Table and Flat File
- 23.4 Source Row Logging
- 23.5 Error Logging Best Practice Architecture
- 24.1 Server Connections
- 24.2 Reusable Workflow Schedules
- 24.3 Reusable Session Configurations
- 24.4 LAB: Create a Sequential Workflow
- 24.5 LAB: Create a Concurrent Workflow
- 25.1 The Command Task
- 25.2 The Email Task
- 25.3 Reusable Task Best Practices
- 26.1 The Decision Task
- 26.2 The Assignment Task
- 26.3 The Timer Task
- 26.4 The Control Task
- 26.5 The Event Wait Task
- 26.6 The Event Raise Task
- 26.7 Non-Reusable Tasks Best Practices
- 26.8 LAB: Create Event Wait/Event Raise and Timer
- 26.9 LAB: Create a Control and Assignment Task
- 26.10 LAB: Create a Command Line Task
- 27.1 Reusable Worklet
- 27.2 Non-Reusable Worklet
- 27.3 Worklet Best Practices
Subscribe to:
Posts (Atom)