Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Import and populate in kettle using postgis

  1. #1
    Join Date
    Mar 2017
    Posts
    2

    Default Import and populate in kettle using postgis

    Hello everyone,

    I'm new at ETL process.

    I'm trying to replicate this repository on Kettle. I have setup the postgreSQL but I'm finding some difficulties around how to really use the postgis in combination with Kettle (bare with me, I only have 2 weeks of contact with Kettle).

    My issue: I want to map the coordinates (pickup and dropoff latitude and longitude) to neighborhood id using postgis.

    I've already created the staging tables in kettle just like in the repository but now I don't know what the next step is.

    I also have the transformation that reads from (one) taxi trip data.csv and corrects some issues and then writes to the database (a test table).

    Now, where/when does the "populate pickup and dropoff location ids in trips during import" step really happen? And how?

    Thank you in advance,

    Esther

  2. #2
    Join Date
    Mar 2017
    Posts
    2

    Default

    Help, please?

Tags for this Thread

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.