Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
Answer Posted / usha
1.Confirmed Dimension:- the dimensions that are bult once
and can be use reused in multiple fact tables
2.Junk Dimension:- the dimension which is used to cerate
junk attributes
3.Degenerated Dimension:- The dimension that are located
in fact table
4.Slowly changing Dimensions:- The dimensions that chaanfes
slowly over a period of time.
Types
SCD type1
SCD type2
SCD type3
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by filter transformation?
What do you understand by a term domain?
What is the commit type if you have a transaction control transformation in the mapping?
What are the advantages of using informatica as an etl tool over teradata?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Explain the tuning lookup transformation - informatica
what is size of u r database?
Explain the mapping variable usage example in informatica
What are the prerequisite tasks to achieve the session partition?
Repository user profiles
What is the need of etl tools?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is update strategy transform?
what is the Default Source Option For Update Strategy Transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?