Talend community forum / tMap not working as expected

scataldi · 2012-06-15 15:35:29

Hi everybody.
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.

Uploaded Images

Last edited by scataldi (2012-06-15 17:53:21)

pedro · 2012-06-18 04:35:33

Hi

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.

Regards,
Pedro

scataldi · 2012-06-18 17:56:37

Thank you very much.
It works now.
Does it means that DI was keeping data in memory so couldn't read the AUTO INCREMENT field?
Thank you once again.
Stefano

pedro · 2012-06-19 03:27:54

Hi Stefano

If you link "DWsoccorsi" with tMap directly, tMap_2 will get rows from tMap_1.
So that's why all ids are 0.

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-06-15 15:35:29

tMap not working as expected

#2 2012-06-18 04:35:33

Re: tMap not working as expected

#3 2012-06-18 17:56:37

Re: tMap not working as expected

#4 2012-06-19 03:27:54

Re: tMap not working as expected

Board footer