Data Warehousing - 2 Types of Tables

Different types of tables in Database : 

1  What is a  Dimensional Table?

This table contains the information in the dimensions.

Dimensions give the information about a measure or a fact. These are informational in nature. Eg: Geographic tables, Regional Tables, Time Tables etc.

In real-time the dimensional tables are generally has about few 100's of rows.

Dimensional Table will only contain the dimensions.

(No Facts at all)

Region ID	Location
10	Chicago
20	Detroit
30	Newyork

2.   What is a Fact Table (Measure)?

Tables that has the calculations and factual numbers are called Fact Tables.

 Fact Table will contain at least one fact column or measure of an dimension.

In real time, the fact tables have about millions of rows.

 Eg: Sales Tables, Profit and Loss Tables, Calculated Data etc

Which kind of tables are generally large in nature?

Fact Tables with million of records. ( One row for every transaction)

  

Sales Table (B) (Fact)

Sales Transaction ID	Sales Amount	Region ID
1450	13 USD	10
1350	25 USD	30
1234	45USD	10

Cognos and Dojo Charts Integration

Cognos can be integrated with third party libraries like Dojo, Javascript etc.

We will need to create a new HTML item in Reports Studio and call the script source libraries from the Server.

Data Warehousing Basics - 1

 I am not here to teach the basics by books which you will never understand. We must only eat whatever we can digest. Will start off with a quick introduction to Datawarehousing.

What is Data ? 

Collection of information. Sales Data, Profit and Loss Statements, HR Data etc.

What does Data contain ?

It consists of subject area specific information on the performance and measure.

Sales Data : Consists of Sales information
HR - Human Resource Info about employees , payrolls etc

What are different types of  Sales data?

Regional Sales , State Sales, City Sales

How is data stored?
Data is stored in Tables.  

How are Tables stored?
Tables are stored in Databases.

What are different kinds of Databases?

ORACLE, MS SQL Server, IBM DB2, Teradata.

Databases softwares which help to store the data at an organization level.

Stored in several number of Databases

What is a database?

Collection of tables in the Database.(mostly subject area related)

How do we retrieve the data from the Database?

By passing set of commands called as "Query"