Data Warehousing
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Data Warehousing as PDF for free.
More details
- Words: 301
- Pages: 2
Email : [email protected] Skype: boaetech
Packages: Informatica, Cognos, Business Objects Data Warehousing Chapter 1: Data warehouse lifecycle Data Warehouse Architecture, Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design. Extract, transform, and load (ETL) Database Design (OLAP- MOLAP, ROLAP & HOLAP) Chapter 2: Informatica 8.x Tool PowerCenter Architecture Informatica Server, Repository and Client Installation & Configuration Security, Server & Repository Management Production Migration & Performance Tuning Source Qualifier/ File Lists/ Workflow Scheduler/Reusable Transformations/ Debugger Detailed Review of the Expression/ Filter/ Sorter/Aggregator/ Joiner/ Lookup/ Update Strategy/ Router/ Sequence Generator Transformations. Source and Target Overrides/ Parameters and Variables/ Self-Join/ incremental Aggregation/ Dynamic Lookup Cache/ Mapplets/ Workflow Configuration and Techniques Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets. Performance tuning. Creating and managing Repository
Chapter 3: Cognos Overview of Data warehousing & Cognos 8 BI Overview of Data warehousing Dimensional Modeling Introduction to Cognos Examine the different studios in Cognos 8 BI BI Architecture
Chapter 4: Framework Manager Data Sources and metadata modeling Data Modeling and relational & dimensional data Types of Relationship in FM Star Schema Grouping Creating Query Subjects/Query Items/Namespace/Filters/Folder Properties of Query Items – Usage Property/Aggregate Property Creating NameSpace/Project, Model and Package. Publishing Package and Exploring Package Chapter 5: Cognos Connection – Web Portal Overview of Cognos Connection Define Report/Run Report Schedule Single/Multiple Report View Report/Run History of a Report/Report Output Version Distribute a Report Create Report Views/Set Preferences Organize Content in Cognos Connection Searching Entries in Cognos Connection Chapter 6: Query Studio Examine Query Studio Create Reports – Lists, Grouped List, Crosstab, Charts. Sorting, Grouping, Filter Add Calculated/Summarized Data Conditional Formatting/Advanced Filters Format a Report
Chapter 6: Report Studio Examine Report Studio Studio Interface with templates Types and formats of reports Explorer Bar/Properties Pane and Variables Examine the Report Specification Layout Components/Query Components Query Model/Tabular Sql
Packages: Informatica, Cognos, Business Objects Data Warehousing Chapter 1: Data warehouse lifecycle Data Warehouse Architecture, Methodologies: Bottom-up design, Top-down design (Inmon/ Kimball Approaches) and Hybrid Design. Extract, transform, and load (ETL) Database Design (OLAP- MOLAP, ROLAP & HOLAP) Chapter 2: Informatica 8.x Tool PowerCenter Architecture Informatica Server, Repository and Client Installation & Configuration Security, Server & Repository Management Production Migration & Performance Tuning Source Qualifier/ File Lists/ Workflow Scheduler/Reusable Transformations/ Debugger Detailed Review of the Expression/ Filter/ Sorter/Aggregator/ Joiner/ Lookup/ Update Strategy/ Router/ Sequence Generator Transformations. Source and Target Overrides/ Parameters and Variables/ Self-Join/ incremental Aggregation/ Dynamic Lookup Cache/ Mapplets/ Workflow Configuration and Techniques Reusable Schedule for a Workflow/ Session Configuration/ Tasks and Worklets. Performance tuning. Creating and managing Repository
Chapter 3: Cognos Overview of Data warehousing & Cognos 8 BI Overview of Data warehousing Dimensional Modeling Introduction to Cognos Examine the different studios in Cognos 8 BI BI Architecture
Chapter 4: Framework Manager Data Sources and metadata modeling Data Modeling and relational & dimensional data Types of Relationship in FM Star Schema Grouping Creating Query Subjects/Query Items/Namespace/Filters/Folder Properties of Query Items – Usage Property/Aggregate Property Creating NameSpace/Project, Model and Package. Publishing Package and Exploring Package Chapter 5: Cognos Connection – Web Portal Overview of Cognos Connection Define Report/Run Report Schedule Single/Multiple Report View Report/Run History of a Report/Report Output Version Distribute a Report Create Report Views/Set Preferences Organize Content in Cognos Connection Searching Entries in Cognos Connection Chapter 6: Query Studio Examine Query Studio Create Reports – Lists, Grouped List, Crosstab, Charts. Sorting, Grouping, Filter Add Calculated/Summarized Data Conditional Formatting/Advanced Filters Format a Report
Chapter 6: Report Studio Examine Report Studio Studio Interface with templates Types and formats of reports Explorer Bar/Properties Pane and Variables Examine the Report Specification Layout Components/Query Components Query Model/Tabular Sql
Related Documents
Data Warehousing
April 2020 35
Data Warehousing
October 2019 40
Data Warehousing
June 2020 23
Data Warehousing
June 2020 24
Data Warehousing
June 2020 33