Data Blending: Combining the info from two or more different sources is Data Blending. we will combine data between two more sort of sources like Oracle, Excel, SQL Server et al. .

Example: Combining the Oracle Table with SQL Server Table (OR) Combining Two Tables from Oracle Database (OR) Combining Two Sheets from Excel (OR) Combining Excel Sheet and Oracle Table then on.

In Data Blending, each data source contains its own set of Dimensions and Measures.

Data Blending is beneficial when there’s a requirement to mix the info from sort of sources like Oracle, DB2, Sybase, SQL Server, Excel Files et al. . we will NOT have common set of Dimensions and Measures which limits to make groups, formulas and other entities across the info .

Data Joining: Combining the info between two or more tables or sheets within an equivalent Data Source is Data Joining.

Example: Combining Two Tables from an equivalent Oracle Database (or) DB2 (or) Sybase (or) SQL Server et al. . Combining two or more worksheets from an equivalent Excel file.

In Data Joining, all the combined tables or sheets contains common set of Dimensions and Measures.

Data Joining is beneficial when there’s a requirement to mix the info from single source but multiple tables or sheets et al. , like two or more Oracle tables or DB2 tables or Sybase tables or SQL Server tables or Excel Files et al. . we will have common set of Dimensions and Measures which extends the power to make groups, formulas and other entities across the info .