Options
data warehouse
Contributor I
hi,
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
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
0
Answers
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.