Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Combination Lookup vs DB Lookup

  1. #1
    Join Date
    Apr 2008
    Posts
    4,696

    Default Combination Lookup vs DB Lookup

    In a given Transform, where I have a SCD2 table, and an incoming stream with just the natural key, and I need the technical key, which is better: the Dimension Lookup, or the DB lookup

    Dated Fact Table:
    OP_ID | SchedDate | ActionDate | Action | Minutes
    1001 | 2009-08-03 | 2009-08-04 | 5 | 720
    1001 | 2009-08-06 | 2009-08-06 | 2 | 300

    SCD2:
    TK | OP_ID | StartDate| EndDate| OP_Name | OP_Status
    1 | 1001 | 0000-00-00 | 2009-08-05 | Smith, Bob | RFT
    2 | 1001 | 2009-08-05 | 9999-12-31 | Smith, Bob | AUX

    Should give (DWFact):
    TK | SchedDate | ActionDate | Action | Minutes
    1 | 2009-08-03 | 2009-08-04 | 5 | 720
    2 | 2009-08-06 | 2009-08-06 | 2 | 300


    As Dated Fact Table and the SCD2 are in *DIFFERENT* DBs, I cannot use a Multi-Table Select in the TableInput. DWFact is going into the same DB as SCD2.
    Last edited by gutlez; 08-06-2009 at 08:41 PM.

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

    Default

    db lookup

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.