Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Create dimension

  1. #1
    Join Date
    Jun 2007
    Posts
    128

    Default Create dimension

    Hi,

    Please anybody tell me how do we need to create a dimension with kettle.
    We need to use dimension lookup/update.But what are the keys we need to give.Key for field in input stream will be the primary key of input table.
    What will be the key for dimension field .Because we haven't created the dimension yet.



    Thanks
    Sreelatha

  2. #2

    Default

    The keys you should enter in keys tab depends on your data. This Fields in the incoming stream for this step should identify your data in your data warehouse.
    For customer data this can be the customers name or his customer-number. It is used to detect if the incoming row is already in the the dimension, if it has to be inserted or updated.
    For further informations on slowly changing dimensions you can read http://www.dbmsmag.com/9604d05.html
    For the key-problem you can read: http://www.dbmsmag.com/9805d05.html

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.