Thursday, 25 October 2012

What is conformed fact? What are conformed dimensions used for? | ETL Testing Interview Questions

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.

No comments: