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
- 4 Answers
- 36306 Views
- IBM, Infotech, I also Faced
- E-Mail Answers
Answer Posted / jyoti
Confirmed Dimension: Dimensions which can be used in more
than one subject area.
Better example is : TIME DIMENSION
Junk Dimensions:Which contains Flags,random values comes
under Junk/Dirty dimensions.
Degenerate Dimension:These dimensions are stored in the
Fact table,but these are not Measures.
Slowly chnaging Dimensions:Dimensions which are chnaging
over time .These are Therr types
1) TYPE1: Will not maintain any history
2) Type 2: will maintain current information as well as
history.
3) Type3: will maintain Part history data
| Is This Answer Correct ? | 19 Yes | 8 No |
Post New Answer View All Answers
What is meant by LDAP users?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
what is size of u r database?
What are mapplets? How is it different from a Reusable Transformation?
What is a predefined event?
Is it possible to revert a global repository to local one and why?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the differences between a connected lookup and unconnected lookup?
How is union transformation utilized?
What is flashback table ? Advance thanks
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What are the differences between oltp and olap?
Explain what is informatica metadata and where is it stored?
What are the static cache and dynamic cache in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
