Are the two data sources being blended? Or are these two separate sheets that are trying to be created? Would it be possible to post the workbook (twbx file)?
I do not believe the data sources are being blended. They are separate extracts and no dimensions from one or the other are intermixed / shared. Yes they are two separate sheets. Sorry, I can't post the data. I know that one data set is fully normallized via a SQL Server Transformation in an SSIS package. I believe the other has been normallized as well, but I'm not sure..