Skip to Content
0

bods: how to use tables from different host in a single sql trasform?

Oct 22, 2017 at 12:34 PM

63

avatar image
Former Member

hi all,

Please suggest on how to use two tables from different host[server] within a single sql transform ?

[to be specific- two tables coming from different datastores ]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Oct 23, 2017 at 12:02 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded