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 HCEMPIDF_NameM_NameL_NameDOJLWD 
Active HCEMPIDF_NameM_NameL_NameDOJTenureAge Bucket

 

New TableEMPIDF_NameM_NameL_NameDOJTenureAge BucketLWD
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

5 Replies

    • 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    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