Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Denormalize tables

  1. #1

    Default Denormalize tables

    I need to take three input tables and end up with a denormalized table. For example:

    Code:
    TABLE A (NO KEYS, DUPLICATES OK)
    F1 F2 F3 F4
    -- -- -- --
    00 00 AA BB
    00 00 AA BB
    00 01 CC DD
    00 01 CC DD
    01 00 EE FF
    01 00 EE FF
    01 01 GG HH
    01 01 GG HH
    
    
    TABLE B PRIMARY KEY(F1,F2)
    F1 F2 F5 F6 F7
    -- -- -- -- --
    00 00 00 00 00
    00 01 11 11 11
    01 00 22 22 22
    01 01 33 33 33
    
    
    TABLE C PRIMARY KEY(F1,F2)
    F1 F2 F8 F9
    -- -- -- --
    00 00 zz yy
    00 01 xx ww
    01 00 vv uu
    01 01 tt ss
    
    
    TABLE D DENORMALIZED
    F1 F2 F3 F4 F5 F6 F7 F8 F9
    -- -- -- -- -- -- -- -- --
    00 00 AA BB 00 00 00 zz yy
    00 00 AA BB 00 00 00 zz yy
    00 01 CC DD 11 11 11 xx ww
    00 01 CC DD 11 11 11 xx ww
    01 00 EE FF 22 22 22 vv uu
    01 00 EE FF 22 22 22 vv uu
    01 01 GG HH 33 33 33 tt ss
    01 01 GG HH 33 33 33 tt ss
    How can I do this in a transform?

    Gerry

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

    Default

    Join the tables? Either in SQL or with the Merge Join 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.