Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
- 3 Answers
- 7919 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / usha
1.Confirmed Dimension:- the dimensions that are bult once
and can be use reused in multiple fact tables
2.Junk Dimension:- the dimension which is used to cerate
junk attributes
3.Degenerated Dimension:- The dimension that are located
in fact table
4.Slowly changing Dimensions:- The dimensions that chaanfes
slowly over a period of time.
Types
SCD type1
SCD type2
SCD type3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is event and what are the tasks related to it?
What are the types of caches in lookup? Explain them.
What is olap (on-line analytical processing?
What are the types of data warehouses?
How to generate sequence numbers?
have u done any performance tuning? how u ll do?
Tell me about MD5 functions in informatica
What is a filter transformation?
What is meant by active and passive transformation?
What are the different options available for update strategy?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Which means the first record should come as last record and last record should come as first record and load into the target file?
What do you mean by enterprise data warehousing?
Differentiate between a repository server and a powerhouse?
What is the benefit of session partitioning?
