Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / mallika
A fact table typically has two types of columns: those that
contain facts and those that are foreign keys to dimension
tables. facts may be composed of measures,degenerated
dimensions.The primary key of a fact table is usually a
composite key that is made up of all of its foreign keys
Dimension tables, also known as lookup or reference tables,
contain the relatively static data in the warehouse.
Dimension tables store the information you normally use to
contain queries. Dimension tables are usually textual and
descriptive and you can use them as the row headers of the
result set. Examples are customers or products
| Is This Answer Correct ? | 107 Yes | 16 No |
Post New Answer View All Answers
What is a cube in data warehousing concept?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What is the extension of file to save template?
How many project sources we can create in metadata?
What is many-to-many dimensional model in datawarehousing ?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Compare and contrast aggregates & indexes
Explain the data type of the surrogate key?
Explain me what are data marts?
What is the function of etl when used in data warehousing?
What are the different ways to represent the loading of dimension tables?
Explain what is difference between query studio and report studio?
