mobileNavlogo
headerlogo

Introduction to IBM COGNOS

Ratings:
(4)
Views:0
Banner-Img
  • Share this blog:

Data Base:

It is a collection of interrelated data (or) it is a collection of objects

OLTP DATABASE: (original transactional processing)

It is used to perform day to day transaction (or) it is used to load day to day transaction data.

OLAP DATABASE: (online analytical processing)

It is used to perform analysis by maintaining all the historic data

DATA WAREHOUSE TOOLS:

Data warehouse tools are categorized into two types

  1. ETL tools
  2. Reporting tools (or) OLAP tools(or) BI tools

ETL tools:

Used to perform extraction transformation and loading

The following are the ETL tools available in the mark etl

  1. Informatica
  2. Data storage
  3. Abinitio
  4. ODI (Oracle data integrator)
  5. BODS (business objects data services)
  6. SSIS (sequel server integrator services)

Reporting tools:

  • Used to generate reports to perform analysis
  • The following are the reporting tools
  1. IBM Cognos
  2. SAP BO (business objects)
  3. Plicro strategy
  4. OBIEE (Oracle business intelligence)
  5. Hyperlan
  6. Qlik view

Fathers of data warehouse:

  1. Raiph Kim ball
  2. WH inmon
  • According to Ralph Kimball, a data warehouse is also a database specify designs for analysis per page but not for running the business
  • According to W.H inmon a data ware house is a time variant, nonvolatile subject oriented and integrated database.

Naming conventions for synonyms for data warehouse: 

  1. DSS : decision supporting system
  2. Historical database
  3. OLAP database
  4. BIS (business intelligence system)
Learn Cognos by Tekslate - Fastest growing sector in the industry. 
Explore  Cognos Training and course is aligned with industry needs & developed by industry veterans. 
Tekslate will turn you into Cognos Expert.

Data ware housing: (imp)  

It is a process of

  • Constructing the data warehouse (or) building the data warehouse (or) designing the DWH schema (database modeling (or) database architects.
  • ETL (ETL developers)

Screenshot_1

Data Acquisition

It is a process of ETL

Architecture of ETL:           

Screenshot_2

For in-depth understanding, Cognos Training click on

You liked the article?

Like : 0

Vote for difficulty

Current difficulty (Avg): Medium

Recommended Courses

1/15

About Author
Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.

Stay Updated

Get stories of change makers and innovators from the startup ecosystem in your inbox