One of our case is to use a data source for BI tool, which data source should be provided on PDI.
Some of the data is on the Hadoop and a part on the DWH.
If the data is on the Hadoop while the report is being generated, the PDI must extract the data from Hadoop.
If the data is over DWH, the PDI must draw the data over DWH.
Do you have any idea to provide this logic table which can decide where to extract the data.