We are using TD14. We have one requirement where we want to join two tables from two different servers.
Is this possible to join such tables in single query?
If No, then please let me know alternatives.
I think it would not be possible for a query to get data from two different servers. One alternative is to copy the smaller table on the other server and then run your query.
you can consult the following thread:
You can fastexport the data from source and then fload into your target. Also you can ask your DBA to do this task. There are other ways to do but these are common and simple ones for one-off job.