Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vensh
Dimension table is nothing but a table which contains detailed description about the data except any values...
Fact table mainly contains the facts nothing but the values that is related to the data in the dimension table and by using the primary key in dimension table and the foreign key in the fact table we will map the dimensional table and the fact table
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
Ist the schema that a data warehouse system can implements.
What is a relationship?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is meta data and system catalog?
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?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is difference between query studio and report studio?
Code the tables statement for a single-level (most common) frequency?
What are the different types of datawarehosuing?
How to create different types of templates?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How can you implement many relations in star schema model?
What is data analysis? Where it will be used?
How many types of facts and what are they?
Explain what is the difference between view filter and report filter?
