Star model

[Anonymous]

I have the following model

//--------------------Assortiment---------------------

Assortiment:

LOAD "Code Article",

    "Code Fournisseur";

SQL SELECT "Code Article",

    "Code Fournisseur"

FROM QlikDataWarehouse.dbo.Assortiment;

//--------------------Fournisseur---------------------

Fournisseur:

LOAD "Code Fournisseur",

    "Libellé Fournisseur",

    Ville;

SQL SELECT "Code Fournisseur",

    "Libellé Fournisseur",

    Ville

FROM QlikDataWarehouse.dbo.Fournisseurs;

How could I modify my script in order to get star model ?

[Anonymous]

You can join the tables that are related to form one or you could rename the names of your fields and create new keys

[marcus_malinow]

As Jannet said, a simple solution would be to join Assortiment and Fournisser like so:

//--------------------Assortiment---------------------

Assortiment:

LOAD "Code Article",

    "Code Fournisseur";

SQL SELECT "Code Article",

    "Code Fournisseur"

FROM QlikDataWarehouse.dbo.Assortiment;

//--------------------Fournisseur---------------------

//Fournisseur:

LEFT JOIN (Assortiment)

LOAD "Code Fournisseur",

    "Libellé Fournisseur",

    Ville;

SQL SELECT "Code Fournisseur",

    "Libellé Fournisseur",

    Ville

FROM QlikDataWarehouse.dbo.Fournisseurs;

[rubenmarin]

If Fournisseur has unique values you can do a (left/inner/outer) join with Assortiment:

//--------------------Assortiment---------------------

Assortiment:

LOAD "Code Article",

    "Code Fournisseur";

SQL SELECT "Code Article",

    "Code Fournisseur"

FROM QlikDataWarehouse.dbo.Assortiment;

Left Join(Assortiment)

LOAD "Code Fournisseur",

    "Libellé Fournisseur",

    Ville;

SQL SELECT "Code Fournisseur",

    "Libellé Fournisseur",

    Ville

FROM QlikDataWarehouse.dbo.Fournisseurs;

[#5]

Jawehar89,

Try to do a left join in script which will drop your physical table structure & keep your data based on join result.

like,

Assortiment:

Load * from Assortiment;

left join (Assortiment)

Load * from Fournisseur;

which should fix your issue.

Thanks

Brad.

[marcus_sommer]

There is no special need to create a datamodel in a star-scheme if you haven't any performance issues. If it's worked it's fine.

- Marcus

[prabhu0505]

I completely agree with Marcus.

Result 1: Note down the size and response time / performance of application in its current form (snow flake model).

Result 2: Convert Snow flake to Star with the guidance's from above post, measure again the size and response time of application.

Compare Result 1 & 2 to come up with best model for your data.

[Anonymous]

you  try  somthing  like  that

//--------------------Assortiment---------------------

Assortiment:

LOAD

    "Code Article" AS % KeyArticle_Assortiment ,

    "Code Fournisseur";

SQL SELECT "Code Article",

    "Code Fournisseur"

FROM QlikDataWarehouse.dbo.Assortiment;

Left Join(Assortiment)

LOAD "Code Fournisseur",

    "Libellé Fournisseur",

    Ville;

SQL SELECT "Code Fournisseur",

    "Libellé Fournisseur",

    Ville

FROM QlikDataWarehouse.dbo.Fournisseurs;

oc:

LOAD

[Code Article] AS % KeyArticle_Oc,

[OC1],

[INSERTION],

[sITE]

FROM..

Article:

load

[Code Article] AS % KeyArticle_Oc,

[Code Article] AS % KeyArticle_Assortiment,

[Libelle Article],

[Unité de Stock]

From

....

Left join(Article:)

REFERENCE:

[Code Article],

[code Refer]

From