Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Oracle Warehouse Builder 11g R2: Getting Started 2011

You're reading from  Oracle Warehouse Builder 11g R2: Getting Started 2011

Product type Book
Published in May 2011
Publisher Packt
ISBN-13 9781849683449
Pages 424 pages
Edition 1st Edition
Languages

Building a code template mapping


Code template mappings are not created under the Mappings node where we've created all our previous regular mappings because they are implemented differently than the regular mappings. To recall, regular mappings were created in the Mappings node, which fell under the Oracle Database node for our project. That is because mappings up until now were mostly only executed in an Oracle database. There are exceptions to that such as flat file loads using the SQL Loader utility or SAP mappings, but for the most part, existing mapping execute in Oracle databases. With the introduction of code template mappings, a single mapping can now be executed across two or more databases and so the node to hold code template mappings was added at the same level as the Databases node in the Projects Navigator hierarchy. It is just to hold all code template mappings, and so is called Template Mappings and it is highlighted in the image below for reference:

All objects created...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}