Skip to Content
avatar image
Former Member

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

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 ]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 23, 2017 at 12:02 PM

    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
    10|10000 characters needed characters exceeded