Hi Folks,
Greeting for the day. I have three tables; table 1, table 2 and table 3. In which table 1 and table 2 have master data hence need to concatenate whereas table 3 is data from system. So, I need to join table 3 with previously concatenate table.
I use the following script;
master:
load * from table 2;
concatenate
load *
from table 2;
right join(Master)
final table:
load * from table 3;
Even though the data is completely loaded, the final table joins with Master table, which consequently result into change of the table name to master table and master table columns are consider at the beginning.
Where as I am looking after joining the table name should be final table and final tables column should be first in the sequence and followed by Master tables columns.
Can you please figure out where, I'm committing mistakes.
Regards,
Sagar.
