Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Generate Static Dimension

  1. #1

    Question Generate Static Dimension

    I have a fairly wide dimension table that is simply a list of indicator fields with known values (i.e. Has Map/No Map). Is there a straightforward way to generate rows that are the combination of all possible values for each field of this dimension?

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

    Default

    Combination Lookup

  3. #3
    Join Date
    Feb 2009
    Posts
    296

    Default

    Go with combination lookup. It does not generate ALL possible values, it only inserts the ones that are within your data.
    Fabian,
    doing ETL with his hands bound on his back

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.