Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Dimension lookup/update - How to avoid insertion of default row ?

  1. #1
    Join Date
    Nov 2016
    Posts
    25

    Exclamation Dimension lookup/update - How to avoid insertion of default row ?

    Hi All,

    I have successfully implemented SCD2 using'Dimension lookup/update' step and only thing that is breaking my logic is PDI automatically inserting default row. This default row is for unknowns with ID = 0 and all other fields = NULL. I understand this row is necessary in a dim table, but for some reasons I don't want this particular row as I have PK constraints defined on a table and that is not allowing me to insert a NULL row.

    Can someone please help me to understand how to avoid or configure PDI in such a way that it does not insert this row ?
    Last edited by sanketk; 03-06-2017 at 03:21 AM.
    TIA,
    Sanket Kelkar.

    PDI CE 6.1
    Oracle 11g
    Windows Server 2012

  2. #2
    Join Date
    Jan 2015
    Posts
    107

    Default

    The only way to avoid it is to manually insert a row with key 0 and 'N/A' or whatever values you want the default row to have in the fields that do not allow NULL. It's also the best way.

Tags for this Thread

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.