Answer Posted / ajitha
factless fact table is fact table but it contains only
referece keys no business measures and mathematical
calculations is called factless fact table
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an er diagram?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Can a dimension table contain numeric values?
Difference between e-r modeling and dimentional modeling?
Is there any rownum object from which we can do this?
Start a batches with in a batch?
What are components of report studio?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
Explain what are the modules in power mart?
How to generate the cubes in framework manager?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
How to know the time taken for particular report execution?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what are components of report studio?