title: How to insert data into destination table without having any primary key in Talend
body: <p>I am using talend for ETL I don't have enough experience in this, I am having two tables for example- <code>account</code> and <code>account_roles</code> account table is having id, name, password etc fields and account_roles table is having <code>account_id</code> which is f.k to account table's pk. and one more field.
  Both the fields in account_roles are having duplicates, I want to save account_roles in destination with <code>update</code> and <code>insert</code> logic using talend.
  But I am getting error as I don't have any table that can be treated as primary key in the account_roles table, so talend can't update or insert it.</p>
  <p>How I deal with this situation I tried tDBOutput advance option <code>use_field_option</code> but still it requires unique entries.
  Is there any possible solution to this issue, I also want to know if I can make table Foreign key in the account_roles table will it work then? If yes then How to make F.k in talend OPen studio is my second question.</p>
  <p>Attaching Snapshots of my tables and tMap below -
  <a href="https://i.stack.imgur.com/N1vq0.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/N1vq0.jpg" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/inAyN.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/inAyN.jpg" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/bibqT.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/bibqT.jpg" alt="enter image description here" /></a></p>
  <p><a href="https://i.stack.imgur.com/BzAaa.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BzAaa.jpg" alt="enter image description here" /></a></p>
  <p>I want to know the way I can put my tables into database if I don't have any primary key! Kindly help me.</p>