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
- 36160 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
Explain about Informatica server process that how it works relates to mapping variables?
What is standalone command task?
what is the Default Source Option For Update Strategy Transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is native users?
explain one complex mapping with logic? sales project?
What are the new features of Power Center 5.0?
define galaxy repository in informatica
What is option by which we can run all the sessions in a batch simultaneously?
What are pre and post-session shell commands?
How to load data in informatica ?
What is the command used to run a batch?
What is an expression transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How many input parameters can exist in an unconnected lookup?
