Differences between Multiprovider and Infoset
Multi-ProviderMulti-Provider is used to Union two or more data-targets, so that we can run query on different data-targets. It also helps us to execute parallel queries.A Multi-Provider can consist of different combinations of the following Info-Providers: Info-Cube, Data-Store object, Info-Object, Info-Set, Virtual-Provider, and aggregation level.
Info-SetsInfo-Sets is used to joins two or more data targets. These joins only combine values that appear in both tables. In contrast to a union, joins form the intersection of the tablesA Info-Sets can consist of different combinations of the following Info-Providers: Info-Cube, Data-Store object and Info-Object.
