-
Notifications
You must be signed in to change notification settings - Fork 0
Overview
This plugin supply a method to join two tables using the date-from and date-to history. It use the two dates that indicate the life of the record and join using a query (like the database join plugin) to resolve the record's story of the two entities.
To install the plugin download the favorite archive from http://sourceforge.net/projects/dihistoryjoinplugin/files/ and extract it in $PENTAHO_DI_HOME/plugins/steps and joy it!
To use the plugin open the category and use the plugin. Open the plugin, you can see all fields:
- Step name
- Connection : The database connection to use
- History date fields (from / to) : The fields that contains the two date (date from and date to) that drive the story.
- History columns (from/to) : The two column that contains the dates used to recreate the story of the principal entity.
- SQL : The query to use for the join. Please remember of add the join condition and the order for the date-from.
- Replace variables : If flagged the variables will replaced in the SQL.
- Parameters to use : Parameters of the query.
All the dates (from and to) <>. If you have null value, you must transform (using a view or the query) in a valid date value (9999-12-31 for example). In the SQL you <> insert a where clause that load the entities in the range of the primary entity for example
date2_to > date1_from and date2_from < date1_to
or
? between date2_from and date2_to
where ? will be set with the reference date