Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Oracle Sequence

  1. #1
    Join Date
    Oct 2008
    Posts
    9

    Default Oracle Sequence

    HI all,

    I'm trying out Kettle from Pentaho. I usually use Informatica Powercenter for ETL but why not use Open Source for a change.

    I've got some problem with the transform Add Sequence. I want to use my oracle seq but when i fill in de fields en run the job i get a message:

    2008/11/13 17:16:30 - Table output Mapping.0 - ERROR (version 3.1.0, build 826 from 2008/09/30 12:32:36) : Couldn't find field <field> in row!

    I know that in de sequence transform the field Name of value is the problem. But what the heck should I fill in here? Tried somethings but that didn't help!

    Regards!

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Ruud, I guess you can pick any name you like. Usually the one you want to put in the database table I guess.
    If you mouse over a step and hit the space bar you see the fields in the output.

    Matt

  3. #3

    Default check the name

    I'm just using this same transformation and i have no problem with this.

    i fill in "name of value" the name of the target column in the database

    in "sequence name " the name of the existing sequence in my Oracle database.

    That's it....

    Try checking this.... maybe you didn't fill the "name of value"

  4. #4
    DEinspanjer Guest

    Default

    Quote Originally Posted by MattCasters View Post
    If you mouse over a step and hit the space bar you see the fields in the output.
    Wow. That's a crazy hidden shortcut. Never knew about it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.