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.
Solved! Go to Solution.
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
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema