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
- 8177 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
Do you find any difficulty while working with flat files as source and target?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is meant by a domain?
what are the deliverables?in your project?
Define the various join types of joiner transformation?
What are the differences between joiner transformation and source qualifier transformation?
How identifying bottlenecks in various components of informatica and resolving them?
How to create the source and target database connections in server manager?
Design time, run time. If you don't create parameter what will happen
Different circumstance which drives informatica server to expel records?
can u give example for factless fact table
What are the features of complex mapping?
how to load dimension table and fact table. plz tell me the steps.
What is a transaction control transformation?
What is the difference between Active and Passive transformation?
