I have two tables in different databases but the column names are same when I am trying to reload it is getting Field names must be Unique how to sort this problem can anyone help me.
unqualify TransID; // If you want a certain one not to qualify, else remove this
select * from tab1;
select * from tab2;
select * from tab3;
Only TransID will be used for associations between the tables tab1, tab2 and tab3.
Don't use table name for qualification. use qualify *; the tables names would be prefixed with the field names automatically.
will generate like T_tab.colu1, T_tab.colu2 fields.