Why null values are mapped as 0 in fact tables?
- 1 Answers
- 1079 Views
- I also Faced
- E-Mail Answers
Answer / Rekha Ranjani
Null values are often mapped as 0 in fact tables to facilitate calculations such as sum, average, and count.
| Is This Answer Correct ? | 0 Yes | 0 No |
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is vldb(very large databases)?
what is Materialized Views?
How to generate iqd file from framework manager?
Explain the hierarchies level data warehousing.
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?
What are the data types present in bo?
What is data warehouse architecture?
What is data stream and data adaopter. Is it same are different? Explain?
what is the use of surrogate key in businessobjects
What is ETL process in Data warehousing?
what is the difference between etl tool and olap tools
Teradata 
