Forum Discussion

unnijoy's avatar
unnijoy
Post Prodigy
5 years ago
Solved

Merge Table

I have two Tables like below. Now i need to merge both table and create a new table. How to do this.  Termintation HC EMPID F_Name M_Name L_Name DOJ LWD   Active HC EMPID F_Name M_Na...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi  unnijoy ,

    Did you try unchecking "Enable parallel loading of tables" under Options, Data Load?

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

unnijoy's avatar
unnijoy
Post Prodigy
5 years ago

hi amitchandak ,

 

yes i followed the same steps. Table 1 contain 63 lack row of data and Table 2 contain 2 lack Row of data. When i merge it is showing as loading and till now its is showing as it had loaded 149700500 rows loaded and its still loading. How is this possible. Did i miss somthing.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    What type of join did you use? Can you post screenshot of the merge queries dialog box?

    • unnijoy's avatar
      unnijoy
      Post Prodigy
      5 years ago

      i use left outer. Below is the screen shote.