Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Kettle Newbie

  1. #1
    Join Date
    Jun 2007
    Posts
    128

    Default Kettle Newbie

    Hi,

    I am new to datawarehousing.I am planning to use Kettle.
    I have some doubts.
    Actually I am trying to build a warehouse using text files.I will receive data in text files every day.Using those files I need to build a warehouse on MySQL.
    Do we need to first load data into MySQL and tghen create dimensons and Facts.How can we create dimensions and facts?
    Anybody please help me.

    Thanks
    Sreelatha

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Best advice for you... rush to the store, buy "The Data Warehouse ETL Toolkit" by Ralph Kimball... the latest edition. And read it.

    On how to proceed... personally I would first load all files to staging tables so that you already have a first sanity check.

    Also look in the Kettle documentation look for the document "Building datawarehouses using open source technologies" ... it may give you a little more feeling with it.

    Regards,
    Sven

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.