Hi, I am a newbie to Talend. I'm having problems inserting "1 to many" relations in an entity. I have created a test model and a test job. I have two data sources (tfixedflowinputs) : PERSON (id, nmperson, statutper) ADRRESS, (id, city, statutadr) My model consists of two entities and two complex types: 1) Entity SDU_PERSON with potentially many addresses (at least one). SDU_PERSON ->SDU_CT_PERSON idperson (auto increment) idreference nmperson statut adrperson -> SDU_CT_ADDRESS idaddress (auto increment) city statut 2) Entity SDU_ADDRESS SDU_ADDRESS -> SDU_CT_ADDRESS idaddress (auto increment) city statut We created an entity address because an address can exist on its own without being linked to a person. (I'm really not sure the solution we implemented is the right way to go about it). As input, we have the following : PERSON (id, nmperson, statutper) (1, "Toto Patafix", false) (2, "Popo Pate", true) ADDRESS (id, city, statutadr) (1, "Mahebourg", true) (2, "Quatre-Bornes", true) (2, "Curepipe", false) To load the MDM (SDU_PERSON entity), we made a tMap between PERSON and ADDRESS, joining keys id. In the MDM, I would have expected to have 2 persons created : - "Toto Patafix" with one address "Mahebourg" - "Popo Pate" with two addresses "Quatre-Bornes" and "Curepipe". But what really happens is that 3 persons are created : - "Toto Patafix" with one address "Mahebourg" - "Popo Pate" with one address "Quatre-Bornes" - "Popo Pate" with one address "Curepipe". I hope my description is clear. It has to be a basic simple thing to do but I really don't know how to go about it. I am enclosing the job and the model. Can someone please help me ? Thanks Sheila
... View more
Hi, I'm a newbie to talend and java. I'm stuck with a problem. I need to insert data into MDM from a MySQL database. So, I have a tMysqlInput component reading rows from a MySQL database. The latter component is linked to a tMap component to transform data which is then sent to a tMDMOutput component for inserting data into the MDM. I have having problems with dateTime values. The field dte_cre of type datetime in MySQL database. Its contents has to be mapped to the field dteCreation of type dateTime in the MDM. The field in the tMap component corresponding to dteCreation is of type Date and date model "dd-MM-yyyy HH:mm:ss". When I execute the job, I get the following error : :-1:-1: cvc-datatype-valid.1.2.1: '06-01-2015 10:04:50' is not a valid value for 'dateTime'. :-1:-1: cvc-type.3.1.3: The value '06-01-2015 10:04:50' of element 'dteCreation' is not valid. I don't understand why I'm getting this error. The value looks very much like a dateTime to me. Can anybody help me please ? Thanks.
... View more