Star Schema Definition

[marco_puccetti]

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

   A,

   B,

   C

From xxx.qvd

Left Join (FACT_TABLE)

Load

  A,

  B,

  D & '#' & 'F' AS KEY

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

DIMENSION_TABLE:

LOAD

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

  E,

  F,

  G

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

Thanks

[jonathandienst]

Does this help:

Left Join (FACT_TABLE)

Load DISTINCT

  A,

  B,

  D & '#' & 'F' AS KEY

[marco_puccetti]

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

[marco_puccetti]

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