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
- 7916 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
write a query to retrieve the latest records from the table sorted by version(scd)
What are connected or unconnected transformations?
What is fact table? Explain the different kinds of facts.
While migrating the data from one environment to another environment how would you manage the connections?
What is repository manager?
What is incremental aggregation?
How do you set a varible in incremental aggregation
How big was your fact table
tell me 5 session failure in real time how can you solve that in your project?
Explian the Process of deployment groups in informatica
What do think which one is the better joiner or look up?
Tell me about MD5 functions in informatica
What is depict expression change?
What is substr in informatica?
In informatics server which files are created during the session rums?
