data warehouse

JoozekJoozek Member Posts: 2 Contributor I
edited November 2018 in Help
I am trying to build a data warehouse with RapidMiner but I can't do one thing. I made my ETL, it works, but when I am starting it, it is sending data to my facts table (first time it is 2200 record which is correct), second time it is 4400 records which is incorrect (I don't add any record to source database). Could you tell me how I can change update mode (which control icon should I use?)
thanks for you responses


  • Options
    BalazsBaranyBalazsBarany Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 Unicorn

    There is an operator "Update Database".

    Read your source data. Insert the Update Database operator, set "attribute filter type" = "subset" and select the ID attribute(s) in the data. RapidMiner will check if those records exist in the target table and update them; if not (i.e. new records), they will be inserted.

    There is a tutorial process in the help text of Update Database.
Sign In or Register to comment.