
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Data Modelling
Hi,
I'm trying to build data model. I've 280 table and there are some columns in each table. And most of the tables has same column names.
Loaded some ten tables, I see there is a synthetic key table was created. I see there some possible ways to eliminate synthetic key
Renaming fields (Using QUALIFY)
Removing fields
Please let me know which is best possible way to create link between all the tables.
Attaching the file for reference.
Thanks,
Srikanth
- Tags:
- new_to_qlikview

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
did you got any solution !!
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dear Srikanth,
I would recommended you to create link/bridge table.
Kind regards,
Ishfaque Ahmed

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Ishfaque Ahmed Since from many days you are not active on community ? where are you ?
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try to concatenate most similar tables and create a FACT LESS FACT Table and then perform the LEFT KEEP on the remaining DIMENSION Tables which will link to FACT and create a STAR SCHEMA.
This method definitely helps and is quite achievable .
Hope this helps
Thanks
CY
