title: Recommended way to "join" dynamodb table with reference table
body: <p>Let's say I got a table in dynamodb called visits which represents websites visits and one of the columns is the location.</p>
  
  <p>In an RDBMS I would have:</p>
  
  <pre><code>visits [id, website_id, ........, location_id ]
  ref_locations [id, city, country, postcode, lat, long]
  </code></pre>
  
  <p>The query we want to do is get me all the visits for this website (so by website id is fine) but I need the location information per visit. Like the city, the country etc. In Sql this is done with a simple join.</p>
  
  <p>What about DynamoDB? I m thinking that we could store the location as a document in the table (hence denormalizing it completely) but I m sure this isn't the right way. </p>
  
  <p>What do you guys do in this situation?</p>
  
  <p>Thanks</p>