Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: parameters doubts

  1. #1
    Join Date
    May 2013
    Posts
    12

    Unhappy parameters doubts

    Hello,


    First of all I thank the help you may offer.


    I explain:


    I have a transformation that is very simple: make a select from a table and insert them into other records.


    I need two things I do not know how to do:


    1. - That when transformation runs, check the records that already exist in the target database and update only those that have changed and insert the new. But they have not changed not touch.


    Two. - I have a field in the source table is VISITDATE. I need to pass as parameter the starting date and records not select records with the field VISITDATE <start date.


    I created, on the tab of the transformation parameters, the startdate parameter, but as I do that by executing a transformation I ask the value of the start date and also make me VISITDATE filter <start date.


    I do not know if I explained well, but thanks anyway.


    Greetings to all!

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Are input and output table in the same database?
    So long, and thanks for all the fish.

  3. #3
    Join Date
    May 2013
    Posts
    12

    Default

    No, are in diferent databases

  4. #4
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Think about how you would do it if you weren't using software to do it, map that out, and then figure out how to do that with the software.

    In your case:

    1) Find the start date (is this a pre-known item, or something the software has to figure out?)
    2) Look up all records in VISITDATE where VISITDATE column >= start date
    3) Insert these records in Destination table

    For this, I would use:
    1) Table Input (assuming that the software needs to figure out start date)
    2) Table Input (to look up the records)
    3) Table Output

    For the requirement to look up updated records - the step that would be useful would be "Insert / Update"
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

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.