Forum Discussion
Question On Data Load and Append (Refreshing data) from Teradata
Hi Argan77 ,
Please check that the four smaller tables are unchecked to enable load.
Similar thread:
Solved: Append vs Append as new for performance
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Thank you for your reply! Oddly enough, it makes little to no difference. This is why I tried splitting the table up in the first place. Each table, regardless of how many other tables are being pulled at the same time from this server, refreshes at about the same speed. The limitation seems to be per connection server side.
I've moved away from the append. It appears like it's doing the union on the server side and then doing the download resulting in the original problem.
I'm now playing with DAX Union(Table1,table2,table3,table4). This seems to be doing what I want; however, I'm not sure how this will work performance wise once we start adding in measures and other calculations. It's also increaseing the size of the file. Is there way to purge the original tables after the union is complete?