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
Explain Association algorithm in Data mining?
Can decision tree be implemented using SQL?
Explain what is data validation strategies for data mart validation after loading process?
How can you set the client management?
What is the difference between view filter and report filter?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain what are components of report studio?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Explain hybrid slowly changing dimension?
What is Active Datawarehousing?
Explain functional dependency?
What are the advantages of cold fusion?
Name a few sectors which use data warehousing?
What is difference between query studio and report studio?
