Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: DataBase Lookup Step "Do not pass row if lookup Fails" question

  1. #1
    Join Date
    Mar 2006
    Posts
    170

    Smile DataBase Lookup Step "Do not pass row if lookup Fails" question

    Hi Matt & Crew!

    Hey once again I want to Thank Everyone for this Kick Ass tool!

    I also want to say that when I search the forum and read some of the older answers from Matt I laugh my ass off :-) I truly appreciate your replys.

    I have a question on the "DataBase Lookup" step.
    I read the Spoon 2.5 manual (RTFM) for info on that step but have a question on the behaviour of not finding a row in a dimension when loading a surrogate for a fact table.

    We have let Kettle create the "0" dummy row in all of our Dimensions so a failed lookup should grab that row if a valid one doesn't exist.

    If we put a "Check" in the "Do not Pass the Row if Lookup Fails" box it doesn't load the default "0" row.

    Is that the correct behaviour?

    If so I'll not put a check in the box.

    Thanks again

    Kent

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

    Default

    lol... the 0 row is only for the dimension/combination step, not for the database lookup step.

    Regards,
    Sven

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

    Default

    read some of the older answers from Matt I laugh my ass off
    Too many asses came off, I had to stop doing that.
    After getting nick-named "The Soup Nazi" it kinda went downhill :-)

    Cheers,
    Matt

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.