February 24, 2013 at 11:11 am
After loading data from SSIS package to target table is it possible to split data from target to dimension and fact and which one is easier to user to generate reports I,e from target or from dimension and fact to reports? Which you prefer to generate report for the user?
February 24, 2013 at 6:00 pm
Theoretically it is possible to have an SSIS package do this. This first package could extract the data from the source system to a “staging area”. Then another process or package could load the data into dimensional tables and finally a third process or package could load the data into the fact tables. As for reporting, I would recommend you read this article from Microsoft on data warehousing. It might not 100% apply to what to you are asking, but it does touch on reporting from dimensional and fact tables, and how it is preferred. Here is the link. (Pay close attention to the star schema.
February 24, 2013 at 6:03 pm
On other comment. I might not recommend a single package do all of that. What I would most likely do if I was designing such a process is use the package to load a staging area. Have another package preaggregate and build the dimensional data and then load into the fact tables for reporting.
February 24, 2013 at 10:47 pm
Thank you for the suggestion
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply