Data Modelling

Report Inappropriate Content · ‎2015-08-26

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

vikasmahajan · ‎2015-12-02

did you got any solution !!

Hope this resolve your issue.
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.

engishfaque · ‎2015-12-02

Dear Srikanth,

I would recommended you to create link/bridge table.

Kind regards,

Ishfaque Ahmed

vikasmahajan · ‎2015-12-02

Hi

Ishfaque Ahmed Since from many days you are not active on community ? where are you ?

Hope this resolve your issue.
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.

prma7799 · ‎2015-12-02

Please go through below link

Synthetic Keys

What is the use of link table?

ychaitanya · ‎2018-04-18

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

Related Topics