To fill up 2 tables from a tMap

Five Stars

To fill up 2 tables from a tMap

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 : 

 

image.png

 

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.


Accepted Solutions
Five Stars

Re: To fill up 2 tables from a tMap

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 Smiley Happy


All Replies
Eleven Stars

Re: To fill up 2 tables from a tMap

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

Regards
Abhishek KUMAR
Five Stars

Re: To fill up 2 tables from a tMap

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 Smiley Happy

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog