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
- 36091 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
scenario where i can use only concurrent execution of workflow.
Can we create multiple integration service on single repository?
What are the types of presistent cache in look up tr.
which one is better performance wise joiner or look up
Explain pushdown optimization and types in informatica
can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the mapping parameters and mapping variables?
What is a pre-defined event and user-defined event?
What is confirmed fact in dataware housing?
How to create the source and target database connections in server manager?
What are the different versions of informatica?
What is the procedure for creating independent data marts from informatica 7.1?
What is the difference between source qualifier transformations source filter to filter transformation?
Differentiate between joiner and lookup transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
