saravanan123

 Profile Answers by saravanan123 Questions by saravanan123

• Aug 18th, 2009

Things to be considered : 1.Check we can get any the existing data`s 2.Check we can clean up the data`s 3.Check we can add new many datas 4.Check we can merge many data`s 5.Check for the limitation of...

MalaiPan

 Profile Answers by MalaiPan Questions by MalaiPan

• Jul 24th, 2009

Loading PerformanceError rateProcess Restart & recovery pointCleansingStatistics on how many row extracted, how many left in each staging and how many loaded into target data warehouse.

Answer Question  Select Best Answer

Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.

sandeepbabu

• Apr 21st, 2014

Maplet is a resuable object,created with business rule using set of transformations and maplet is created with i/p maplet transformation and o/p tarnsformation. Maplet can be created without i/p maplet transformation.

It can be divided into two type:

1)active maplet
2)Passive maplet

abhishek_upadhyay

 Profile Answers by abhishek_upadhyay Questions by abhishek_upadhyay

• Sep 18th, 2008

Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer.

Answer Question  Select Best Answer

set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.

Read Best Answer

Editorial / Best Answer

ManishTewatia  

 Profile Answers by ManishTewatia Questions by ManishTewatia

• Member Since Jul-2010 | Jul 22nd, 2010

---

What Md.Rehman is trying to say is catagorizing the SCD which are the Slowly Changing Dimensions which are used to maintain historical data.

Dimension:A dimension is an organized hierarchy of categories, known as levels, that describes data in data warehouse fact tables

The various types of dimensions are :

1) Shared and Private Dimensions: Describes the basic differences between shared and private dimensions and their uses

2) Regular Dimensions: Provides information about regular dimensions and their variations

3) Parent-Child Dimensions: Describes the creation of parent-child dimensions and identifies their advantages and restrictions

4) Data Mining Dimensions: Describes the creation of data mining dimensions and identifies advantages and restrictions to their use

5) Virtual Dimensions:Describes the creation of virtual dimensions and their advantages and restrictions

6) Dependent Dimensions: Describes the creation of dependent dimensions and identifies their advantages and restrictions

7) Write-Enabled Dimensions: Describes the creation of write-enabled dimensions and identifies their advantages and restrictions

VIKRAM KUMAR

• Mar 1st, 2018

Dimensions are of several types but we use few commonly which are, 1. Confirmed dim. dim. shared by all fact tables. ex- time dim. 2. Slow changing dim. it is of 3 types : SCD1. SCD2, SCD3., 3. Role ...

Venu Gaddam

 Profile Answers by Venu Gaddam Questions by Venu Gaddam

• Dec 23rd, 2010

Dimensions are of 3 types mainly in case of slowly changing dimensions: Type 1 -> Does not maintain any history and is update only. --> this is normal practice mappings.Type 2-> Maintains full histor...

Improve Answer