Runtime column definition for Oracle Stage
Posted: Mon Aug 18, 2008 8:06 am
Hi,
Apologise if I am repeating a previously posted query. My search has not yeilded any results.
Is there anyway to provide runtime column defintion for Oracle source stage? I have over 200 tables to be loaded which read from Oracle table itself and simply do an insert to another table. Is there anything like schema files (of sequential file stage) for Oracle by which I could avoid creating multiple jobs?
Currently the extract and load has been implemented using Perl scripting and needs to be converted to Datastage.
Thanks.
Apologise if I am repeating a previously posted query. My search has not yeilded any results.
Is there anyway to provide runtime column defintion for Oracle source stage? I have over 200 tables to be loaded which read from Oracle table itself and simply do an insert to another table. Is there anything like schema files (of sequential file stage) for Oracle by which I could avoid creating multiple jobs?
Currently the extract and load has been implemented using Perl scripting and needs to be converted to Datastage.
Thanks.