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
- 7918 Views
- Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raveendra g
One dimension which used more than one cube called
Confirmed dimension.
Junk dimension is nothing but Durty. We have to take
unrelated attributes and data into maintain single table
called junk dimension.
DD: The value of the dimension which is stored in the
factable called Degenerated Dimension
SCD: The value of the dimension is happen to change very
rarely and commonly called SCD.
3 Types of SCDS we are having
SCD1: Only current
SCD2: Current+History, Here we can add rows
SCD3: Current+just recent, Here we can add columns level
data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / vasu
check all pevious Questions and Answers in
Allinterview.com
| Is This Answer Correct ? | 1 Yes | 9 No |
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
can we load the data with out a primary key of a table? what is target plan?
How you count the number of records available at your source?
Difference Between ETL & ELT?
what is worklet and what use of worklet and in which situation we can use it?
What is a dimensional model?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the methods for creating reusable transforamtions?
What are the data movement modes in informatcia?
How can you access the remote source into your session?
What is the difference between lookup override and souce qualifier override ?
How can you define user defied event?
Teradata 
