Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Dimension lookup/update

  1. #1

    Default Dimension lookup/update

    In dimension lookup/update,I tried to update my dimension table.But I'm getting the following error

    Error inserting 'unknown' row in dimension [TEST_DM] : insert into TEST_DM(BRAND_DM_KEY, version) values (0, 1).

    My dimension table contains the following field.

    brand_dm_key(pk),brand_name,code,Abbreviation_lbl ,all columns are not null.

    I created the columns version,date_from and date_to fields.

    How to overcome these errors.

    please help me ASAP

    preetha

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    You miss a version column apparently... and you can insert the "0 row" yourself upfront. The 0 row (1 row in some databases) is used to indicate unknown values. PDI won't insert/change the 0 row if it already exists.

    Look at e.g. http://wiki.pentaho.com/display/EAI/...+Lookup-Update

    Regards,
    Sven
    Last edited by sboden; 11-13-2008 at 11:33 AM.

  3. #3
    DEinspanjer Guest

    Default

    What exactly did you try? Since you have several fields with not-null requirements, Kettle isn't going to be able to insert the unknown record itself. You need to do that.
    Once you have inserted this record, if you are still getting an error, please run a very small testcase in debugging log level and post the relevant section of the log.

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.