Null values are often mapped as 0 in fact tables to facilitate calculations

Why null values are mapped as 0 in fact tables?

Question Posted / Rekha Ranjani

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is the purpose of Dataware Control?

1123

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2352

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6093

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1050

Explain how to generate iqd file from framework manager?

1031