Access two schemas in one stage

gomathy · Post by **gomathy** » Wed Dec 18, 2002 7:04 am

Is it possible to access tables from two different schemas in a single stage.?
For instance in a ORAOCI8 plugin, the tables in the Input tab and Output tab of the plugin are in different schemas.
How do we pass the db access parameters since there is a facility to provide for only one in the ORAOCI8 plugin stage?

chulett · Post by **chulett** » Wed Dec 18, 2002 8:14 am

Short answer is no.

Long answer is you can't access multiple schemas via a single plugin stage. You will have to use two different OCI8 stages. Depending on the situation, you may have to play some games to get it to work, but it certainly should be possible. Why don't you explain in detail what you are trying to do and we'll see if we can help?

-craig

ray.wurlod · Post by **ray.wurlod** » Wed Dec 18, 2002 3:42 pm

The reason the answer is no is that the connection is a property of the stage, not of the link.
There ought to be no difficulty using two stages in your example, with just a link between them.

gomathy · Post by **gomathy** » Mon Dec 23, 2002 3:54 am

thanx..
the problem we faced was few columns of table1 needs to b updated from table2.
table1 is the output from a transformer stage..Instead of having table2 as lookup ,we tried giving it in the output tab of the oraoci8 plugin linked to transformer2 map the columns to b updated and here table1 is the output..this was thought about since lookup degrades performance.

Thanks,
Gomathy

mihai · Post by **mihai** » Mon Dec 23, 2002 6:58 am

Alternatively, you could set some synonyms in schema1 pointing to tables in schema2. The down-side is that you will need to be careful with security (i.e. permissions/grants) in Oracle.

Mihai

_________________
desk: 01908448571