TriplesMap1
type: TriplesMap
logical source:
  source: DB source
  sql version: SQL2008
  query: SELECT EMP.*, (CASE job WHEN 'CLERK' THEN 'general-office' WHEN 'NIGHTGUARD' THEN 'security' WHEN 'ENGINEER' THEN 'engineering' END) AS ROLE FROM EMP
  reference formulation: CSV
subject map:
  template: http://data.example.com/employee/{empno}
predicate object map:
  predicate: role
  object map:
    template: http://data.example.com/roles/{role}

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