Multiprovider works on the concept of union of all
infoproviders but the info set works on the concept of
intersection of the data in the fields available in the
different infoproviders
Multi provider:A multi provider is a type of info provider
that combines the number of infoproviders and make it
available for reporting.These infoproviders combines one to
another by Union Operation.Union operation is used to
combine the info cube,DSO,Info object, and Info set.Multi
provider does not contain any data itself.
Info set:Info set combine the data from one or more number
of info providers based on the joints.
we have 4 types of joints.
1. Equi Join,
2. Left outer join,
3. Right outer join,
4. Temporally join/self join
milti provider;the multi provider is atype of info provide. that compainds data from a number of info providers and make it to available for reporting.
info set;the info set describes data source that are usually defined as joins for ods or info objects.