Skip to Content
0

DBLink in Derived table in MultiSource Universe

Nov 02, 2016 at 10:52 AM

74

avatar image

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".

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

0 Answers