What are dimension mapping and fact mapping?

Question: What are dimension mapping and fact mapping?

Chuck Kelley’s Answer: That depends on how and where it is used. It could be the process of mapping data from the source to its location in either a dimension or fact (assuming the target is a dimensional model). It could be, if they are speaking about Informatica, trying to understand if the code being written/executed is a mapping for a dimension or a fact. Since I don’t know the context, I am sorry that I cannot be much help.

Chuck Kelley is an internationally known expert in database and data warehousing technology. He has 30 years of experience in designing and implementing operational/production systems and data warehouses. Kelley has worked in some facet of the design and implementation phase of more than 50 data warehouses and data marts. He also teaches seminars, co-authored four books on data warehousing and has been published in many trade magazines on database technology, data warehousing and enterprise data strategies. He can be contacted at chuckkelley@usa.net.

For more information on related topics, visit the following channels:

• DW Basics
• DW Design, Methodology