topic Star Schema Definition in QlikView

Star Schema Definition

marco_puccetti — Fri, 07 Aug 2015 08:58:59 GMT

Hello i have created a star schema with all the dimension's table primary key in the fact table, but i have noticed that the fact table load multiple, one line for each line of the dimension table.

This is the example to create the fact table:

FACT_TABLE:

Load

From xxx.qvd

Left Join (FACT_TABLE)

Load

D & '#' & 'F' AS KEY

On the other hand i have loaded the following dimension table:

DIMENSION_TABLE:

LOAD

D & '#' & 'F' AS KEY,

Anybody knows if this is ok or there is a method to avoid it?

Thanks

Re: Star Schema Definition

jonathandienst — Fri, 07 Aug 2015 09:05:35 GMT

Does this help:

Left Join (FACT_TABLE)

Load DISTINCT

D & '#' & 'F' AS KEY

Re: Star Schema Definition

marco_puccetti — Fri, 07 Aug 2015 09:31:40 GMT

This not solve because the Fact Table Join on A and B field, but the Dimension Table contains more than one distinct row, one for each Fact Table row.

The molteplicity between the fact table and Dimension table is 1..N

Any solution?

Marco

Re: Star Schema Definition

marco_puccetti — Fri, 07 Aug 2015 12:56:50 GMT

I have read that to work the star schema, each record in a dimension table can describe many records in the fact table isn't it?

Marco