What is dimension table and fact table in informatica?
Answers
Answered by
0
Dimension tables are used to describe dimensions; they contain dimension keys, values and attributes. In general dimension tables holds the description / textual information about facts stored in fact tables. The fact tables contains foreign keys referring to the dimension tables.
Answered by
0
Answer:
Dimension tables are typically small, ranging from a few to several thousand rows. A fact table is a table that contains summarized numerical and historical data (facts) and a multipart index composed of foreign keys from the primary keys of related dimension tables.
Similar questions