Search found 2 matches

by gomathy
Mon Dec 23, 2002 3:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Access two schemas in one stage
Replies: 4
Views: 1212

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 ...
by gomathy
Wed Dec 18, 2002 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Access two schemas in one stage
Replies: 4
Views: 1212

Access two schemas in one stage

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