Answer Posted / ramu
Fact table is a table which contains primary key and foreign key(pk ,fk1,fk2...)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are parallel querys and query hints?
What is the difference between view materialized view and view?
Explain what is full load & incremental or refresh load?
What is the difference between a primary and secondary actor in use case modeling?
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
Explain the data type of the surrogate key?
How are the dimension tables designed?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Compare and contrast aggregates & indexes
Why null values are mapped as 0 in fact tables?
What is aggregate fact table?
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.
What are the different types of join operations?
What are the differences between star and snowflake schema?
How can you clear the cache?