Data Warehousing Concepts:

  • Introduction
  • What is Data Warehouse
  • ETL Concepts
  • Data mart
  • Fact Table
  • Dimensions Table
  • Cubes and Schema Concepts
  • OLTP and OLAP Concepts

Business Objects Architecture and Admin Support:

  • What is Business Objects & their different Versions
  • Business Objects XI3.1 Architecture
  • Architecture Components
  • What is CCM(Central Configuration Manager)
  • What is SIA(Server intelligent Agent)
  • What is CMC(Central Management Console)
  • Different types of Authentication
  • Creating Security through CMC (Central Management Console)
  • Creating Groups
  • Creating Users
  • Creating Folders
  • Creating User Security and Privileges
  • Creating Security on Universe and Universe Connections
  • Creating Security on Applications wise

Universe Designer:

  • What is Universe Designer
  • Understanding how universes allow users to query databases using their everyday business terms
  • Creating connection to Database.
  • Building the universe structures
  • Creating the Universe and Setting parameters
  • Defining Joins
  • Creating Classes & Dimension Objects
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Applying Restrictions on Objects
  • Working with hierarchies
  • Deployment – Learn how to distribute, document, and maintain universes.

Report Building in InfoView: (Web Intelligence)

  • What is InfoView
  • Managing documents in InfoView
  • Viewing a Web Intelligence document in InfoView
  • Creating a new Web Intelligence document using Universe
  • Create a query based on an Excel file
  • Modifying a document’s query
  • Working with query properties
  • Modifying a query with a predefined query filter
  • Using prompts to restrict data
  • Using complex filters at Query level
  • Using Filters at Report Level
  • Displaying data in tables and charts
  • Using breaks, calculations, sorts and report filters
  • Ranking data to see top or bottom values
  • Using Alerters to highlight information
  • Copying data to other applications
  • Using formulas and variables in the Java Report Panel
  • Creating multiple queries in a document
  • Drilling in the Java Report Panel
  • Add a hyperlink to a document
  • Merge dimensions from different universes
  • Create an input control for a document
  • Viewing and Editing Customized Sql
  • Scheduling a Web Intelligence document
  • Publish a document to the CMS

 

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)

Introduction to Cognos

  • About Cognos 8.4 and Cognos 10
  • 3 – Tier Architecture
  • Cognos Release (EP series7, Reportnet , Cognos 8.0/8,1/8.2/8.3/8.4/10)
  • Features of Cognos 8.4
  • Cognos Vs other OLAP tools
  • Cognos components (Modeling & Reporting)
  • Different cognos services

Cognos Connections

  • 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

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

Report Studio

  • 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
  • Static 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 (separate course not included in this package)

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

Analysis Studio

  • 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

Event Studio

  • Creating Agents
  • Adding Event conditions
  • Task and Task execution rules
  • Scheduling Agents

 

ABINITIO COURSE CONTENT

  1. Abinitio Course Contents
  2. Introduction to Abinitio
  3. Abinitio Architecture
  4. Graph Programming
  5. Introduction to .dat and .dml files

Partition Components

  • Braod Cast
  • Partition by Expression
  • Partition by range
  • Partition by community
  • Partition by percentage
  • Partition by Round Robin

Departition Components

  • Concatenate
  • Gather
  • Interleave
  • Merge

Multifile System(MFS)

Types of parallelism Layouts

Sort Components

  • Sort
  • Sort with in groups
  • Sample
  • Partition by key and sort

Transform Components

  • Filter by expression
  • Aggregate
  • Scan
  • Rollup
  • Denormalize Sorted
  • Normalize
  • Reformat
  • Match sorted
  • Dedup sorted

Working with Databases

Database Components

  • Run SQL
  • Input Table
  • Output Table
  • Truncate Table
  • Update table

Miscellaneous Components

  • Gather logs
  • Run program
  • Redefine format
  • Trash
  • Replicate

Dataset Components

  • Input File
  • Output File
  • Lookup File
  • Intermediate File

FTP Components

  • FTP From
  • FTP To

Compress Components

  • Compress
  • Uncompress
  • Gzip
  • Gunzip

Validate Components

  • Check Order
  • Generate Records
  • Generate Random bytes
  • Compare Records
  • Compute Check Sum
  • Compare Check Sum

Translate Components

  • Record XML
  • Write XML

 

DATASTAGE Course Content

  • Data Warehouse Concepts, Design.
  • Need of Data Warehouse.
  • Introduction to OLTP, ETL and OLAP Systems.
  • Data Warehousing Architecture.
  • Dimensional Modeling.
  • Data Marts and ODS.
  • Star Schema and Snowflake Schema.
  • Types of Fact and Dimension Tables.
  • Testing of Data warehouse.
  • FAQ’s.

ORACLE CONCEPTS

  • Introduction to Oracle.
  • Data Types.
  • Select statement usage.
  • Joins.
  • Sub Queries.
  • Performance Tuning Tips & Tricks.
  • FAQ’s.

 DATASTAGE-INTRODUCTION

  • Introduction to ETL.
  • ETL Architecture.
  • Datastage Architecture.
  • Installation & Configuration of Datastage.
  • Creation of the Project.

DATASTAGE-CREATING DATASTAGE JOBS

  • Design the Datastage jobs.
  • Compile and Running jobs.
  • View the job log and debugging of jobs.
  • Simple and Complex jobs.
  • Jobs creation with Multiple Sources.
  • Multiple Targets.

TRANSFORMING DATA

  • Using the Active stages and passive stages.
  • Example of each Transformation available.
  • Working with Relational Data.
  • Slowly Changing Dimensions.
  • Performance tuning techniques.
  • Handle errors and exceptions.
  • Stage Variables, Derivations and Constraints.
  • Functions.

 Platform Architecture:

  • Describing configuration files.
  • Defining Environmental Variables.
  • Defining Job level parameters.
  • Describing Runtime column propagations.
  • Exporting and importing the jobs.
  • Clear the logs and Cleanup the Resources.
  • Job Sequences and Job Activity.

 ADVANTAGES

  • Real-time Scenarios.
  • Deployment Process.
  • Project Experience.
  • Resume Preparation.
  • Mock Interviews.
  • FAQ’s.
  • Job Assistance.

 

Informatica Course Content
Data warehouse basics
  • OLTP System
  • Data warehouse
  • Different Definitions of data warehouse
  • Difference between OPERATIONAL DS AND DWH
  • Types of ETL
  • Data Extraction
  • Data Transformation
  • Data Merging
  • Data Loading
  • Types of Data loading
  • Data Aggregation
  • Data warehouse Approaches
  • Top down approach and Bottom up approach
  • DW Life cycle
  • DW-database design
  • Star schema and Snow flake schema
  • Facts and dimensions
  • Granuality
  • Types of Dimensions
  • Types of fact table
  • Types of Olap
Informatica Power Center 8.6
Power center Administration
  • Informatica Power center architecture
  • Power center components
  • ETL Plan
  • Power center Clients
  • Designer
  • Workflow manager
  • Work Flow monitor
  • Workflow manager
  • Repository manager
  • Power center repository
  • Administrative tool
  • Repository services
  • Integration services
  • Power center domain
  • Application services
  • Concept of nodes and grid
  • Service manager
  • Power center administration console
Repository Administration
  • Creating Repository Users and Groups .
  • Connecting to the Repository.
  • Creating a Group
  • Assigning Privileges to a Group.
  • Creating a User
  • Creating a Folder
  • Folder Permissions
  • Creating Folders
Using the designer
  • Creating Source Tables.
  • Creating Target Definitions.
  • Creating Target Tables
  • Creating a Pass-Through Mapping
  • Creating source definitions
  • Creating a Mapping
  • Connecting Transformations
Transformation Creation
  • Using Transformations
  • Creating a Mapping with Aggregate Values
  • Active and passive transformations
  • Creating an Aggregator Transformation
  • Creating an Expression Transformation
  • Creating a Lookup Transformation
  • Connecting the Target
  • Designer Tips.
  • Using the Overview Window
  • Arranging Transformations
  • Creating the Session
  • Creating the Workflow
  • Creating a Mapping with Fact and Dimension Tables
  • Creating a Filter Transformation
  • Creating a Sequence Generator Transformation
  • Creating a Stored Procedure Transformation
  • Completing the Mapping
  • Creating a Workflow
  • Creating a Link Condition.
  • Running the Workflow
XML sources and Monitoring loads
  • Using XML Files
  • Creating the XML Source
  • Importing the XML Source
  • Editing the XML Definition
  • Creating the Target
  • Creating a Mapping with XML Sources and Targets
  • Creating an Expression Transformation
  • Creating Router Transformations
  • Completing the Mapping
  • Creating a Workflow
  • How to monitor loads
  • Use of Workflow monitor
Using the workflow manager
  • Connecting Transformations
  • Creating Sessions and Workflows
  • Configuring Database Connections in the Workflow Manager
  • Creating a Reusable Session
  • Creating a Workflow
  • Running and Monitoring Workflows
  • Opening the Workflow Monitor
  • Running the Workflow
Workflow Tasks
  • Session
  • Assignment task
  • Link task
  • Event raise task
  • Event wait task
  • Timer task
  • Post session and Pre-session commands
  • Session recovery
  • Commit points
  • Creation of Parameter file
  • Mapping and session parameter

Performance tuning in ETL
  • Various optimization technique
  • Pushdown optimization
  • Incremental aggregation

Creating a Simple Shell Script

  • Introduction
  • The Shell as a Programming Language
  • Creating Shell Scripts
  • Some Basics
  • Input and Output Redirection
  • Scripts vs Compiled Programs
  • Shell Script Examples

Filename Generation & Quoting

  • Introduction
  • Metacharacters
  • Filename Generation Characters
  • Filename Generation
  • Quoting
  • The Comment Character

Using Shell Variables in Scripts

  • Introduction
  • Creating and Referencing Variables
  • Executing Files
  • An Example Process Hierarchy
  • visibility of Shell Variables
  • The Environment of a Process

Arithmetic Operations in Shell

  • Introduction
  • Arithmetic operation using expr command
  • Familiarizing with let
  • Arithmetic operation using parenthesis

Arrays

  • Introduction
  • Declaring an array
  • Processing values in Array
  • Pass / return array to/from functions

Input for Shell Scripts

  • Introduction
  • Command Substitution
  • Interactive Input for Shell Scripts
  • Command Line Input
  • Catching Signals
  • Partial Quoting
  • Overview of Shell Interpretations

Using Conditional Constructs

  • Introduction
  • Flow Control Constructs
  • The case Construct
  • Return Values
  • The exit Command
  • Using the if and test Commands
  • Moving Command Arguments
  • Conditional Operators

Using Looping Constructs

  • Introduction
  • Overview of Looping Constructs
  • Looping Over a List
  • Skipping Items
  • Generating Word Lists
  • Waiting for Something to Happen
  • Looping While a Condition Holds
  • More about break and continue
  • Redirection

Redirections

  • Introduction
  • Redirecting STDOUT and STDERR to file
  • Converting STDOUT to STDERR
  • Converting STDERR to STDOUT
  • Appending to a file

Advanced Topics

  • Cut command
  • Text processing with awk , sed
  • Grep , find commands in detail
Sgraph Infotech
MSBI | DOT NET | AWS | Data Science | Python
Address :
3rd Floor, JP Royale- 90/4, Above ICICI Bank, Outer Ring Road, Opposite Radisson Blu, Marathahalli,
Bengaluru,
Karnataka - 560037
India.
Tel : 9620885025
Email : sgraphinfotech@gmail.com

OUR TRAINING COURSES

Best Android Training in Marathahalli Bangalore

Best .Net Training in Bangalore

Best Oracle SQL Training Institutes in Bangalore

Best PLSQL Training Centers in Bangalore

Best Big Data and Hadoop Training Courses in Bangalore

Best MSBI Training Institutes in Bangalore

Best Microsoft Power BI Training Bangalore

Best Oracle DBA Training at Bangalore

CONTACT FORM

© 2016 | All rights reserved |Developed By Nexevo Technologies | Sitemap