Thanks for your response. Let me put my requirement in simple way.
1. I have a table data in informix (let us say t1 is the table and employee_id is the column name and the data from 1 to 10 is present)
2. This data is moved to oracle using some XXXX tool
3. Now i will have to check that in Oracle table (let us say t1_1 is the table and employee_id is the column and the data is moved 1 to 9 only but the 10 is missing in oracle)
4. This missing 10, I would like to capture in the excel.
One more question, let us say i have two informix tables which needs to be joined and then one oracle table join these two tables using tmap and then output in excel. So ihave done one informix table and one oracle table before but i haven't tried two informix table and one oracle table.
As shown in the attached screenshot, i am unable to add synonym, Could you please assist? I am trying to connect Informix db, so is it issue in talend or any other permission issue in informix db?