Hello everybody,

My job try to insert or update datas from an oracle export to a mysql
eav model.

here's some example of datas stores in a eav model (attributes are links to another table which describe attributes datas)

Existance is match against some attributes in the model, not on primary
keys which are not know in oracle export.
For the moment, I map my model in this way:

Which is the better way to check if record already exists?
I was thinking in this way: make a MysqlInput which make me an export of
all datas and check in map if there is a record with all attributes used
for keys: this method should give me records with primary key and
records without and so switch between insert or update.

it's seems that tMap allow me with unique match and inner join like in
this topic http://www.talendforge.org/forum/viewtopic.php?id=3739 so I
can check key exists. But when I insert, I need the key inserted.
tMysqlLastInsertId should be fine, but is there an easy way to add
tMysqlLastInsertId in a tMap or did I need to:
- insert or update first in the entity table
- fetch insert row or entity_id found and add attributes in a second way.

hope you can help me
best regards

Matthieu

PS: if you have others comments or better way about my job to design it
easily, I'll appreciate your help.