From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

To fill up 2 tables from a tMap

Highlighted
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
Highlighted
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

View solution in original post


All Replies
Highlighted
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
Highlighted
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

View solution in original post

2019 GARTNER 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

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Put Massive Amounts of Data to Work

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

Watch Now