Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Denomalization

  1. #1

    Default Denomalization

    Hello,

    I am working on Normalizing a huge data or around 10 million data using the step denormalizer.

    below are the input and ouput..


    ACCOUNT_ID NAME (String) VALUE (String)
    1111 CITY Springs
    1111 FIRST_NAME XXXX
    1111 HOUSE_NUMBER 0000
    1111 LAST_NAME YYYY
    1111 STATE CA
    1111 STREET_NAME King rd
    1111 ZIP 60123

    And the output i need is as

    ACCOUNT_ID CITY FIRST_NAME HOUSE_NUMBER LAST_NAME 1111 Springs XXXX 0000 YYYY

    STATE STREET_NAME ZIP
    CA KINGS RD 60123

    Can i achieve the same using Denormalizer ?? I am tired of using all the options there ...

    If so let me know the settings and if not which step can be used ??


    Thanks in advance

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

    Default

    Easy with the "denormalizer" step: the group key would be ACCOUNT_ID in your example.
    The key field "NAME"
    Then you simply create new fields for all the different occurences of "Name" like "CITY", "FIRST_NAME", etc.

    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.