3 Replies Latest reply: Nov 30, 2017 9:08 AM by Constantin Olaru RSS

    Concatenate vs link table

    Élio Godinho

      Good afternoon,

       

      I am developing a data model and I ask the second one:

       

      I have three tables of facts many different fields and the same dimensions.

       

      Example:

       

      Fact1:

      Dim1

      Dimi2

      Measure1

      Measure2

      Measure3

      Measure4

      Measure5

      Measure6

       

      Fact2:

      Dim1

      Dimi2

      Measure1

      Measure2

      Measure3

       

      Fact3

      Dim1

      Dimi2

      Measure1

      Measure2

      Measure3

      Measure4

      Measure5

      Measure6

      Measure7

      Measure8

      Measure9

      Measure10

      Measure11

      Measure12

      Measure13

      Measure14

      Measure15

      Measure16

       

      What is the best choice? Conactenate or linktable?

       

      Using concatenate I get a single table with multiple fields with null values.


      What is the impact of having multiple fields with null values in the table?

       

       

      Best regards.

       

      Élio Godinho