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.
Runtime column definition for Oracle Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Has anyone actually verified that? On one class that I attended it was asserted that RCP enabled yielded the same result as "SELECT * FROM tablename" at least when using the Enterprise stage types. This was given as a warning - you can get badly burned if the table has 15,000 columns! But I have never tested it, and am not currently in a position to be able to do so.piyu wrote:Let me clarify:
The source stage metadata needs to be supplied at runtime as well.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.