Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Dimension lookup/update steps not inserting all values

  1. #1
    Join Date
    Apr 2007
    Posts
    21

    Default Dimension lookup/update steps not inserting all values

    Hi,

    I have a dimension table that has quite a few fields - lot_key (surrogate), lot_name, lot_date, lot_id, version.

    I configured dimension lookup/update as follows:
    -"Keys" tab to lookup - all of above fields (except version)
    -"Fields" tab to update - all of above fields with "Insert" update mode.

    When I run the step, it tries to insert but it only inserts the lot_key and version columns and not the other columns. The insert failed as I specified not-null for all the other columns.

    I have also checked "Update the dimension".

    Any idea what is missing?

    Thanks

  2. #2
    Join Date
    Apr 2007
    Posts
    21

    Default

    To clarify further, the "Dimension lookup/update" stop only pick up the technical key and version number to insert.
    It seems to ignore all the other fields, despite including in the "Fields" table.

    Is this the normal behaviour of the step?

    Thanks

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

    Default

    Did you insert an "unknown" row into your dimension? (usually tk 0 or 1)

  4. #4
    Join Date
    Apr 2007
    Posts
    21

    Default

    Yes, your are right. It does say "unknown", with a tk of 1.

    Am new to PDI. What does this mean?

    Thanks

  5. #5
    Join Date
    Apr 2007
    Posts
    21

    Default

    Hi,

    Manage to find the answers in the archives ;-) and gotten the step to work

    basically, had to create the first row - tk=0 and everything works fine.

    Thanks

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.