<div>
Thank you for your help.I am posting another question to figure out my load of the Fact table. Can you please take a look and let me know your thoughts. I will post the link to my new question. Thanks so much
</div>


Thank you for your help.I am posting another question to figure out my load of the Fact table. Can you please take a look and let me know your thoughts. I will post the link to my new question. Thanks so much

<div>
I couldnt find the ID of my new question? The title was Load Fact table in SQL Server SSIS package. I hope this helps
</div>


I couldnt find the ID of my new question? The title was Load Fact table in SQL Server SSIS package. I hope this helps

<div>
<div class="content wysiwyg-content">
We currently have a process that tracks errors with submissions. The current process is a job that has multiple tables that are joined and inserted into a final table. This final tables data was to be used for reporting and I suggested building a small cube with this data. My initial thought was to create dimensions with all the tables in the procedure and insert into a fact table, with start schema, &nbsp;and use this for reporting. <br />
My first question is when using Oracle data source in a SQL Server BI solution, what is the best way to do this when the tables are fairly large? Should I create an SSIS package and bring the data from Oracle into staging tables and then create the cube in SQL Server based off of these staging tables?
</div>
</div>


We currently have a process that tracks errors with submissions. The current process is a job that has multiple tables that are joined and inserted into a final table. This final tables data was to be used for reporting and I suggested building a small cube with this data. My initial thought was to create dimensions with all the tables in the procedure and insert into a fact table, with start schema,  and use this for reporting. 
My first question is when using Oracle data source in a SQL Server BI solution, what is the best way to do this when the tables are fairly large? Should I create an SSIS package and bring the data from Oracle into staging tables and then create the cube in SQL Server based off of these staging tables?

Creating a SQLServer BI cube from Oracle data source

Business Intelligence (BI)

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.