You are not logged in.
I have a tMap not working as I expected in DI 5.1.1 and older versions:
as shown in the attached images, a tMap lookup table (raw3) has an Auto Increment field ("id", used as Primary Key) that I wish to put in the "mezzi" table as a key link.
The value taken from that field and put in "mezzi" is alway 0.
Another field from the same lookup table is put regularly in the "mezzi" table.
What's wrong with this behaviour? Sorry but I haven't find any solution in the manual and the forum.
Googling around I have found other people with the same problem. Is seems that Talend DI can't read an AUTO INCREMENT PRIMARY KEY and write it somewhere. I have tried writing it through tFileOutputDelimited, tGreenplumOutputBulk etc... The content of the "id" field is always 0.
Thank you very much for any suggestion.
Last edited by scataldi (2012-06-15 17:53:21)
Welcome to Talend Community!
I think the job design is not correct here. I see you link "DWsoccorsi" with tMap directly.
You'd better use a tMysqlInput as a subjob to get records from "DWsoccorsi" table.
Or all ids are 0.