TriplesMap1
type: TriplesMap
logical source:
  source: DB source
  sql version: SQL2008
  query: SELECT Student.ID as ID, Student.FirstName as FirstName, Student.LastName as LastName, Sport.Description as Description, Sport.ID as Sport_ID FROM Student,Sport,Student_Sport WHERE Student.ID = Student_Sport.ID_Student AND Sport.ID = Student_Sport.ID_Sport;
  reference formulation: CSV
subject map:
  template: http://example.com/{id}/{firstname}
predicate object map:
  predicate: id
  object map:
    reference: id
predicate object map:
  predicate: firstName
  object map:
    reference: firstname
predicate object map:
  predicate: lastName
  object map:
    reference: lastname
predicate object map:
  predicate: plays
  object map:
    template: http://example.com/{sport_id}/{description}

TriplesMap2
type: TriplesMap
logical table:
  table name: Sport
subject map:
  template: http://example.com/{id}/{description}
predicate object map:
  predicate: id
  object map:
    reference: id
predicate object map:
  predicate: description
  object map:
    reference: description

DB source
type: Database
jdbc DSN: CONNECTIONDSN
jdbc driver: org.postgresql.Driver
username: postgres