Hi,
Is there a way we can access/import tables through database links in DI for eg
SELECT * FROM RDS.Tp@RDS_SOURCE
I need to access this table TP and I have the database link. And I have also added the database link in the linked datastore .
How do i import this table tp into the datastore?
swethavs7 (BOB member since 2009-03-25)
you can’t import tables using links, you will have to create Datstore using the connection for the linked Database and import the table
you can import DB links in datastore for a source datastore to indicate that the source table is accesible from this datastore using DB links
This DB link information will be used by Optimizer to pushdown SQL, for example if you have table A used as source and table B used as target, A is imported in DS1 and B is imported in DS2, and you have a database link for A which can be accesed from DB on which table B exists, then you can import that link in DS2 for source datasore DS1
if you have DF which uses A as source and B as target, then DI will generate a SQL as INSERT INTO B SELECT … FROM A@db_link
if you don’t want to do this then you have following options
use a SQL transform, you can use SQL with DB link in that ,there is no need to import DB link in Datastore for this
or
Create a View in the DB using the SQL using DB link and import that View in the datastore
manoj_d (BOB member since 2009-01-02)