Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - Explain in detail with example about Confirmed Dimension, Junk Dimension, Degenerated Dimension, Slowly changing Dimensions?




1209
views
asked marvit September 20, 2014 08:05 AM  

Explain in detail with example about Confirmed Dimension, Junk Dimension, Degenerated Dimension, Slowly changing Dimensions?


           

1 Answers



 
answered By vishnoiprem   0  
1.Confirmed Dimension:
The dimensions which is used more than one fact table is called conformed dimensions.
Ex-Product Dimension related to Order fact, Sles fact..

2.Junk Dimension:
A "junk" dimension is a collection of random transactional codes, flags and/or text attributes that are unrelated to any particular dimension.
A good example would be a trade fact in a company that brokers equity trades.
fact would contain several metrics (principal amount,net amount, price per share, commission, margin amount, etc.) and would be related to several dimensions such as account, date, rep, office, exchange, etc.

3.Degenerated Dimension:
In a data warehouse, a degenerate dimension is a dimension which is derived from the fact table and doesn't have its own dimension table.
ex-line no in a Facttable,

4.Slowly changing Dimensions:
A Slowly Changing Dimension (SCD)is a dimension that changes over time.It may change immediately and it may also change quite rapidly.
ex-nothing but Inserts,updates
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert