Please explain in detail with example about
1.Confirmed Dimension.
2.Junk Dimension.
3.Degenerated Dimension.
4.Slowly changing Dimensions
Answer Posted / msr
1.A dimension table which can be shared by multiple fact
tables is know as confirmed dimension.
2.A junk diemesion with type discriptive data boolean , flag
datatype can't be used to discribed the key performance
integrator are know as junk dimension for
exple:productdiscription,address,zipcode,phone number
if a table contains the values which are neither dimension nor
measure is called degenerate dimensions for
exple:invoice-id,empno
Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
How big was your fact table
4 yrs etl devloper roles and responsibilities?any body give solutions
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What are the components of the workflow manager?
How do you promote a non-reusable transformation to reusable transformation?
Differentiate between a database and data warehouse?
How identifying bottlenecks in various components of informatica and resolving them?
How can a transformation be made reusable?
How many ways a relational source definition can be updated and what are they?
What is the need for an etl tool?
What are data-driven sessions?
What is data transformation manager process?
What is union transformation?
Explain incremental aggregation in informatica
What is confirmed fact in dataware housing?