Search found 2 matches
- 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 ...
- 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...