Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-08-26 10:02 AM

Qlikview and Data modelling

Hi,

I have a problem with my data modelling because datas repeat themselves

Do you know any best pratices to avoid this problem

You can see my star modelling in attached file

Yours faithfully,

Preview file
86 KB
628 Views
0 Likes
1 Reply
Not applicable
‎2010-08-26 10:25 AM
Author

There are two approaches:

1) combine tables LIVRAISON_MD, COMMANDE_MD and OBJCMDE into one table

2) if 1 is not possible, load separate client information for each of the three above tables with different table names and different PK field names like:

LIVRAISON_CLIENT.LIVRAISON_CODECLI to LIVRAISON_MD.LIVRAISON_CODECLI

COMMANDE_CLIENT.COMMANDE_CODECLI to COMMANDE_MD.COMMANDE_CODECLI

OBJCMD_CLIENT.OBJCMDE_CODECLI to OBJCMDE.OBJCMDE_CODECLI

301 Views
0 Likes