July 9, 2008 at 4:32 pm
Is it possible in BI studio to use a time dimensino table from Teradata and a fact table from Oracle built in two separate DSV's? I can't find a way to connect them.
July 9, 2008 at 10:24 pm
Is there a requirement to actually have the two DSV's? ie you can bring in tables/objects from different datasources in to the one dsv?
Steve.
July 10, 2008 at 9:57 am
Sorry, should have seen that. You can only create a DSV by initially attaching to one DS and you can add tables to that DSV from other DS's. That works great. When I try to process the time dim from Teradata, it only tries to connect to Oracle (fact table) since that is the DS the DSV was initially attached to. It seems to ignore the DS actually attached to the time table.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply