This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I am trying to create a simple data load from an Excel spreadsheet to an Oracle Database. The primary key for the table to be loaded is an Oracle Sequence. There is nothing in the Oracle Bulk Loader that addresses sequences.
How do I integrate the Add sequence under "Transform" to insert a new sequence number into a Table while loading data.
I have tried using it as a step that passes along the next value to the Excel spreadsheet but have not been able to get it to actually load the data. Is there documentation on this any where? Do you cover this topic in your book?