Multiple Fact Tables

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply