Skip to Content
avatar image
Former Member

DBLink in Derived table in MultiSource Universe

Hi All,

I'm creating multisource universe and connecting it to Oracle and Teradata databases. I created derived table which will is taking union of from tables of both databases. I'm able to validate query.

SELECT @catalog('TD_CATALOG')."SCM1"."TBL1"."COL"FROM @catalog('TD_CATALOG')."SCM1"."TBL1"

UNION

SELECT @catalog('ORA_CATALOG')."SCM2"."TBL2"."COL"FROM @catalog('ORA_CATALOG')."SCM1"."TBL2"

.but when I'm trying to access table using dblink in same way as above. I'm getting error "table not found".

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers