• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

"Add Sequence" (with Pentaho and Oracle)  RSS feed

 
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
We cannot change unless we survive, but we will not survive unless we change. Evolving tiny ad:
ScroogeXHTML - small and flexible RTF to HTML converter library
https://coderanch.com/t/710903/ScroogeXHTML-RTF-HTML-XHTML-converter
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!