To fill up 2 tables from a tMap

[Anonymous]

Hello everyone,

i want to analyse multiple excel files from the same folder in order to fill up 2 differents tables with the same primary Key. My talend look like this at the moment : 

My problem is that i don't have the same number of lines in the 2 tables although i should have, because they have the same primary key. I have approximatively 284 000 in my first table, which is the number i'm looking for. And 231 000 in the second table 'achat_tmp'.

Any idea ? 

Thanks for the reading.

[akumar2301]

There could be many reason for this .

1) Attach an reject output to each of tOracleOutput and check if there are any rejects.

1) Also  please print tOracleOutput Global Var and check how many record Inserted/Updated/Rejected

((Integer)globalMap.get("tOracleOutput_1_NB_LINE_UPDATED"))((Integer)globalMap.get("tOracleOutput_1_NB_LINE_INSERTED"))((Integer)globalMap.get("tOracleOutput_1_NB_LINE_REJECTED"))

[Anonymous · Accepted solution]

Hi, thanks for your help, but the problem was somewhere else.

I'm using Heidi SQL, and for a reason, it's not writing the good number. I checked with php MyAdmin and some request, and everything is ok from the start... 

Thanks anyway