What Is Conformed Fact? What Are Conformed Dimensions Used For?

1.	What Is Conformed Fact? What Are Conformed Dimensions Used For?
Answer» CONFORMED fact in a warehouse allows itself to have same name in SEPARATE tables. They can be compared and combined mathematically. Conformed dimensions can be used across multiple data MARTS. They have a STATIC structure. Any DIMENSION table that is used by multiple fact tables can be conformed dimensions. Conformed fact in a warehouse allows itself to have same name in separate tables. They can be compared and combined mathematically. Conformed dimensions can be used across multiple data marts. They have a static structure. Any dimension table that is used by multiple fact tables can be conformed dimensions.

Answer»

CONFORMED fact in a warehouse allows itself to have same name in SEPARATE tables. They can be compared and combined mathematically. Conformed dimensions can be used across multiple data MARTS. They have a STATIC structure. Any DIMENSION table that is used by multiple fact tables can be conformed dimensions.

Conformed fact in a warehouse allows itself to have same name in separate tables. They can be compared and combined mathematically. Conformed dimensions can be used across multiple data marts. They have a static structure. Any dimension table that is used by multiple fact tables can be conformed dimensions.

Discussion

No Comment Found

Related InterviewSolutions

Techniques Of Error Handling - Ignore , Rejecting Bad Records To A Flat File , Loading The Records And Reviewing Them (default Values)?
What Is The Difference Between Joiner And Lookup?
What Are The Various Test Procedures Used To Check Whether The Data Is Loaded In The Backend, Performance Of The Mapping, And Quality Of The Data Loaded In Informatica?
Where Do We Use Connected And Un Connected Lookups?
What Is The Difference Between Informatica 7.0&8.0?
How Can I Edit The Xml Target, Are There Anyways Apart From The Editing The Xsd File. Can I Directly Edit The Xml Directly In Informatica Designer?
What Is Conformed Fact? What Are Conformed Dimensions Used For?
Define Non-additive Facts?
What Is Data Purging?
What Are The Different Problems That Data Mining Can Slove?