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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Learn how to make your data more available, reduce costs and cut your build time