Data blending is used when we have to use data from more than one data source in a single workbook.
Data blending based on the common dimension used to join both the databases.
Two data source used in data blending referred as a primary data source and secondary data source.
A small chain image appears next to the dimension which is common between both data sources.
Data blending is used for combining data from one Data source with column data from other data source in a single table.
Why data blending is useful over join-
1- Data is at different granularity.
2- Data is not supported by cross database join
Data blending based on the common dimension used to join both the databases.
Two data source used in data blending referred as a primary data source and secondary data source.
A small chain image appears next to the dimension which is common between both data sources.
Data blending is used for combining data from one Data source with column data from other data source in a single table.
Why data blending is useful over join-
1- Data is at different granularity.
2- Data is not supported by cross database join
No comments:
Post a Comment