nareshcnr

 Profile Answers by nareshcnr Questions by nareshcnr

• Nov 6th, 2017

Types of Dimension tables : There are mainly three types of dimension tables available in case of Slowly Changing Dimensions Type 1: Never maintain historical data. only update the existing data. e...

Johnny

• Aug 31st, 2017

The following are the type of dimensions
Slowly changing
Fast Changing
Inferred
Junk
Conformed
Degenerate, and
Static

Answer Question  Select Best Answer

Answered by swetha on 2005-03-30 12:00:33: OLTP  Current data Short database transactions Online update/insert/delete Normalization is promoted High volume transactions Transaction recovery is necessary   OLAP Current and historical data Long database transactions Batch update/insert/delete Denormalization is promoted Low...

ram

• Aug 30th, 2016

OLTP: Original Source of data
Running on fundamental business task

OLAP: Data coming from various OLTP sources
Problem Solving, Decision Making

Pravin

• Jan 16th, 2015

Very useful answer.
thanks.

Answer Question  Select Best Answer