Also interesting to state that the stored procedures have SET XACT_ABORT ON

Thanks a lot

Thank you Jeff, but what are you using inside your company to manage hierarchies? are you using SQL Server MDM ? you do you create your own code? thanks

Thank you Jason, but what are you using inside your company to manage hierarchies? are you using SQL Server MDM ? you do you create your own code? thanks

Is this option possible only if the source is a data file? can the source be oracle instead of a data file?

Fast Load Options

If the OLE DB destination uses a...

DEar Frederico,

Please see my replies below:

you got SQL Enterprise or other?

Not sure.

Is this incremental or full load? if incremental how do you deternime inserts/update/deletes?

It's full load. We truncate the...

Sorry this last answer I did not understood.

I got this reply in my company:

"On a object you can setup...

I don't expet to havemuch more data. but more data will  needed.

Solution is composed by:

1 staging area , one data mart one tabular cube.

We...

sorry. Let me had more verbose to it.

This is a MSBI reporting tool.

We consume infromation from an oracle DB into our staging area using SSIS. Then...

Thank you very much. Let me just add another point. We are using tabular model and we expect to have millions and millions of rows on the facts. I don't...

Thank you for your support.

Thank you for your  reply. We have a bi application that takes information from views that that exist in an oracle db.  We get this information into our side into...

Because we have several things in our backlog that are very important also. So, if upgrading to 2017 is not important from a powerbi perspective then we can consider the...