Answer Posted / srinivas
a fact less fact table is a numeric and summerized value
but it is not a business measurment value.
example:
in emp bonus table is a fact less fact table.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain why denormalization is promoted in universe designing?
How did you plan your Data ware house project?
Explain what are the various transformation available?
For faster process, what we will do with the universe?
Is there any default username & pwd for bo designer & supervisor?
Database in use is oracle?
Explain why dimenstion tables are denormalized in nature?
What is the difference between constraind base load ordering and target load plan?
What is the function of etl when used in data warehousing?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is a fact, dimension, measure?
Explain dimension table ?
Is there any difference in testing database and data ware housing?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?