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
- 8023 Views
- Infotech, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Tell me about Propagate functions in informatica
Differences between connected and unconnected lookup?
Reusable transformation and shortcut differences
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is data movement mode in Informatica and difference between them?
What are the new features of Power Center 5.0?
What is rank transformation in informatica
What is a filter transformation?
What is aggregator transformation in informatica?
How to generate sequence numbers using expression transformation?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How we can create indexes after completing the loan process?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
