Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Building a single dimension from different input fields in the stream

  1. #1
    Join Date
    Apr 2014
    Posts
    1

    Default Building a single dimension from different input fields in the stream

    I have a CSV file where a number of fields f1, f2, ..., fn semantically represents values in the same dimension. On a single row in the file, only ONE of f1 - fn will be set at the same time. What I need to do in the transformation, is


    1. For each new unique value of f1-fn appearing in the stream, store it in dimension table D
    2. Output the new PK of D to the stream
    3. Store the new PK value as a foreign key in the fact table F at some later step in the transformation


    I guess this could be done by some sort of combined lookup, but the challenge is that it is not a single field f that shall be looked up, but many, and mapped to the same foreign key in the fact table.

    Is there a more elegant way do do this than creating a transformation for each f1-fn??

    Thanks in advance,

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

    Default

    Have you looked at the Combination lookup / update step and the Dimension lookup / Update step?

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.