topic To fill up 2 tables from a tMap in Talend Studio

To fill up 2 tables from a tMap

Anonymous — Sat, 16 Nov 2024 06:27:35 GMT

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.

Re: To fill up 2 tables from a tMap

akumar2301 — Thu, 28 Feb 2019 15:02:19 GMT

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"))

Re: To fill up 2 tables from a tMap

Anonymous — Fri, 01 Mar 2019 15:30:45 GMT

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