Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
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 |
If u select groupby port in aggregator what is output and dont select groupby option what is output
what is polling?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
What will be the approach?
When we are using Dynamic Cache,which options we will select in session level?
daily how much amount of data send to production?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
How to do the error handling of if ur source is flatfiles?
How can you complete unrcoverable sessions?
How to open an older version of an object in the workspace?
What is sql query override? When did u use sql query override?