Hi Swetha N,
SQL pushes down SELECT to database and if you join tables from different servers and it will throw error as in SQL transform you will give Datastore name in which the tables exists. So you have 2 options
1. load those 2 tables data to a common staging data and do join.
2. Try creating Database links and use SQL tarnsform to join the 2 tables using database links in SQL transform ( I never tried this and im not sure if this will work out, Just try it yourself and see if it works)
Thanks,
Ravi kiran.
Add comment