Multiple Fact Tables

• yrstruly

  Hall of Fame

  Points: 3477

  More actions

  July 5, 2022 at 10:08 am

  #4059016

  Please assist? I would like to do a data model of the tables here: https://developers.google.com/doubleclick-advertisers/dtv2/reference/match-tables

  Any idea how i would go about to break this down and build a decent data model/links to tables?

• Eirikur Eiriksson

  SSC Guru

  Points: 182945

  More actions

  July 5, 2022 at 1:36 pm

  #4059107

  Simple solution here, copy the text of the whole section, paste into a good text/code editor (notepad++, vim etc.) and create a ddl and dml for the tables. Then use a diagram editor of your choice (dia, yEd, Visio etc.) to populate a ERD for the tables. Alternatively, run the scripts in an SQL Database and use the built in diagram tool.

  

  Obviously there is some find and replace and such work involved but that should not be an obstacle.