amar_smmath

 Profile Answers by amar_smmath Questions by amar_smmath

• May 14th, 2006

 

the difft. types of dimensions are

 1.confirmed 2.junk dimension

1.confirmed: confirmed dimension is that dimension table which has 100% relationship to share with the other tables.

sreedhar

• May 27th, 2006

 

it is very simple generate numbers by using sq _ trsfms for both tbls and perform the fjoins

Manas

• Jun 2nd, 2006

 

Anothe approch would be... create one dummy fileld by an expression in both. Then join the two using the dummy field.

kareemuddin ahmed

• Jun 24th, 2006

 

what is junk dimeasion?

Motilal

• Jun 30th, 2006

 

There are many types of dimension tables.

Till now there have no particular type of classification.

You can find them in "Datawarehousing Toolkit" by Ralf Kimphbell.

Some of them are,-Confirmed, Junk, Degenerated, Time, Demographic, Slowly Changing, Rapidly Changing, etc.. around 16 types are there.

mr.kishorev

 Profile Answers by mr.kishorev 

• Feb 9th, 2010

 

Junk Dimensions are the dimension tables which will not be used for analysing or reporting purpose in DWH.

hundwanipankaj

 Profile Answers by hundwanipankaj 

• Apr 5th, 2010

 

Dimension table types
 1. Slow changing dimensions
 2. Junk dimensions
 3. Confirmed dimension
 4. Degenrated dimension

Jaspreet_banga

 Profile Answers by Jaspreet_banga Questions by Jaspreet_banga

• Jun 8th, 2011

 

For such type of Join we can use INNER JOIN, The best example for this is when we fetch data from a flat file source and the date for which the data has to be fetched is taken from a table known as job control table, which is in database so usiing the inner join we can not only join two tables but two different structures of tables also..