• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

Introduction to IBM COGNOS

Data Base:

It is a collection of inter related 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 WARE HOUSE TOOLS:

Data ware house 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 ware house:

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

 

Naming conventions for synonyms for data ware house: 

  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 Online 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 ware house (or) building the data ware house (or) designing the DWH schema (database modeling (or) data base architects.
  • ETL (ETL developers)

 

Screenshot_1

 

Data Acquisition

It is a process of ETL

 

 

Architecture of ETL:           

 

Screenshot_2

 

For indepth understanding Cognos Training click on

Summary
Review Date
Reviewed Item
Introduction to IBM COGNOS
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Introduction to IBM COGNOS"

Leave a Message

Your email address will not be published. Required fields are marked *

Site Disclaimer, Copyright © 2016 - All Rights Reserved.