consider a trade company which consists of fact about trading that take places in a share trading firm.in these there may be some facts like mode of trade(which indicates whether the user is trading through phone or online)which will be not related to any of the dimensions such as account,date,indices,amount of share etc.
so these unrelated facts are removed from the fact table and stored as a separate dimension as a junk dimension which will be useful to provide extra information
A junk dimension is a table containing all known or given
combinations of two or more other dimensions. It is then
used as a lookup from a fact table to find the combination
of dimensions that relate to that fact. The purpose is to
declutter and reduce the width of the fact table.
An example might be a [SalesFact] table which references a
junk dimension [SalesExtentionDIM] containing values/SKs
for dimensions of [OnSaleYN] , [SaleCodeSK] , [ColourSK] ,
A Dimension with the type of descriptive information like flog,button or not used describe the key performance indicators known as facts is called as junk dimension
ex: product description,phone,fax, address ,etc..
Is This Answer Correct ?
Other Data Warehouse General Interview Questions
Select * from emp,dept,loc where emp.deptno left outer join
dept.deptno and dept.locno=loc.locno.
No need to consider the syntax but is it possible to have
left outer join and equi join in the same SQL like this ?
can we have right outer join and left outer join in the
same SQL ---
Hi Cognos Folks,
I have all cognos certification dumps. In fact i am
certified in most of the dumps recently. I have cognos
material, pdfs, user guides, documents along with dumps. If
any one required cognos dumps, please drop me mail at
Cognos bi user