Hi:
I'm a total NB in OWB (10.2) and I'd like to know the steps to do something that I think is simple. Most of the OBE and written examples I've seen seem to want to talk about cubes etc. which I don't need.
I want to take a schema, S, and transform it only slightly, and then have all the data migrated to the target schema T (or at least have OWB generate the scripts to do that).
Assuming OWB is installed and I have two existing databases, one which has S in it already and one that has an empty T schema(?), what I think I need to do in OWB is something like:
<ul><li>Create the source DB S</li>
<li>Create the source connection</li>
<li>Import everything into the model for S from the underlying source DB
</li>
<li>Create the target DB T
</li>
<li>Create the target connection</li>
<li>Create the modified table in T from S (This is what I'm not sure how to do. Is this a mapping, and the Transform comes later when moving data? How do I do this? Create the object as needed in T and map the table from S to T?)</li>
<li>Create the transformation that shows how to convert data from S so it goes into T</li>
<li>Save everything</li>
<li>Deploy to T which results in... What? A file that is a build script and a set of data migration scripts?
</li>
</ul>
Say, for instance, I just have some tables with VARCHAR2(4000) and LONG columns and I want those tables to have CLOBS (LOBS? I understand TO_CLOB doesn't work with LONG?) in the target schema. I am looking to create the table with CLOBS in the target schema and have OWB generate the code to move the data from S to T.
I'm looking at the documentation but it isn't giving me a succinct example yet that I can see. Any URL to particular documents with that would be appreciated.
Thanks