Types aggregate

Description for "Oracle OBIEE corporate training in India" OBIEE 11g , OBIEE 10g , Siebel Analytics ,Obia Dac Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions( SCD ) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

​Description for "Oracle OBIEE corporate training in India" OBIEE 11g , OBIEE 10g , Siebel Analytics ,Obia Dac sadguru technologies 040-40154733-8179736190 Data warehouse Concepts · Data warehouse · Data mart · Basics of Data Warehousing · What is OLTP and OLAP? · Difference between OLTP and OLAP · Dimensional Modeling Overview · Introduction to Dimensional Modeling · Dimensional table · Fact table · Aggregate table · Star schema · Snowflake schema · Star schema Vs. Snowflake schema · Fact Vs. Dimension table · Fact Vs. Aggregate Table · Types of Facts · Types of Fact tables · Types of Dimensions · Level of Granularity · Grain of fact · Slowly Changing Dimensions( SCD ) · Normalization · DE normalization OBIEE Overview · Introduction to Siebel Analytics · Introduction to OBIEE 10 G · What is Obiee? · Advantages of Obiee · End to End Life Cycle of Obiee · Types of Reports · Types of Applications · Components OF Obiee · Client Components Of Obiee · Obiee Architecture · Difference between Obiee 10g and Siebel Analytics · Difference between Obiee 10g

COGNOS Course Content Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Cognos Course Detail COGNOS Course Content @ Learning Hub 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 • Types Of Facts • Types Of Dimensions • ETL • Staging Area • Concepts of Schemas (Star schema & Snowflake schema) • CLP Modeling • Industry leading ETL and Reporting tools INTRODUCTION TO COGNOS • About Cognos • 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) COGNOS CONNECTIONS • Personalize Cognos Connection • Create and manage portals, shortcuts, report views..etc • Running the Report Burn • Scheduling Reports • Various Options in Cognos Connection REPORT STUDIO • Report Studio User Interface • Creating, Save and run reports • Managing Reports. • Creating list, Cross Tab etc. • Report templates, formatting Reports – fonts, style, header, footer, boarder…etc • Filters, Parameters and Prompts • Subtotals and Calculations • Working with Queries • Generating and Creating Prompt Page • Types Of Reports • Types of Prompts • Types of Variables • Query Calculations & Layout Calculations • Filters and Dynamic Filters • Conditional Block • Conditional Formatting • Master Details • Cascading Prompt • Operators • Setting Burst Options • Drill through • Setting Variables • Report Functions • Report Validation • Reports Run with Options • Different types of Reports with various functionalities • Unions • Joins • Components and there properties. QUERY STUDIO • 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 ANALYSIS STUDIO • Insert Data • 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 FRAMEWORK MANAGER • 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 Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in

Data Stage Course Content at Traning at learning hub Magarpatta city /FC Road Pune (+91-93257-93756) www.learninghub.co.in Data Stage Data Stage Course Content at Learning Hub Contents • Introduction about Data Stage • Difference between Server Jobs and Parallel Jobs • Difference between Pipeline Parallelisms • Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto) • Configuration File • Difference between SMP/MPD architecture • Data Stage Components (Server components/Client Components) • Package Installer Data Stage Administrator • Creating project, Editing project and Deleting project • Permissions to user • .Apt Config file • Environment variable creation, permission Data stage director • Introduction to Data stage Director • Job status View • View logs • Scheduling • Batches Creation Designer • Introduction about Designer • Repository • Palatte • Types of Links • File Stages • Sequential File • Data set File • Lookup file set • Difference between Sequential file/Dataset/File set • Database stages • Dynamic RDBMS • Oracle Enterprise • ODBC Enterprise • Stored Procedure Processing stages • Change Capture (Caption) • Compare stage • Difference Stage • Aggregate Stage • Transformer Stage • Surrogate Generator Stage • Join Generator Stage • Merge Generator Stage • Lookup Generator Stage • Difference between join/Lookup/Merge • Difference between join/Lookup • Remove Duplicates • Switch • Pivot • Modify • Funnel Debugging stage • Head • Tail • Pea • Row Generator • Column Generator • Sample • Job Parameters Manager • Introduction About Data stage Manager • Importing the Job • Exporting the Job • Importing Table Definition • Importing Flat File Definition • Routines Containers • Difference between Local Container and Shared Container • Local Container • Shared Container Please Contact- Learning Hub, S-12,Destination Centre, 2nd Floor, Above HDFC Bank, Next to Noble Polyclinic, MAGARPATTA CITY, PUNE – 411013, PH: +91- 93257-93756. Skype id : learning.hub01 Email: learninghub01@gmail.com www.learninghub.co.in Data Stage Online Training, Data Stage Class Room Training, Data Stage Training in Magarpatta City, Data Stage Jobs and Placement, Data Stage Remote Support, Data Stage Online Help,Data Stage Videos training, Data Stage training by Learning Hub, Fast track classes in Data Stage, Best Data Stage training institutes in Pune, Best Faculty in Data Stage, Best online Faculty in Data Stage, Professional classroom training in Data Stage, Professional online training in Data Stage,Data Stage Certification, Data Stage training in Dubai, Data StageTraining in Melbourne, Data Stage Training in Dubai, Data Stage Training, Data Stage Training,Data Stage Training, Data StageOnline Training, Data Stage certfication and suppor