Thank you Pablo!

I will try to incorporate your design suggestion. We are still on design stage, so I am trying different design schema.

Thanks for your response.

Yes. Original Fact visit still hold some information. Problem is, new facts I am trying to bringing in have different granularity.

For each visit, patient could have...

I got this problem finally resolved. So the trick was in the beginning of the stored proc, I just had to declare all column values like following:

if 1=2

begin

select

CAST(NULL...

@Phil

Actual code has #ID. I made mistake while I was copying the code.

This is the error I am getting:

Exception from HRESULT: 0xC0202009

Error at Data Flow Task [OLE DB Source...

index portion of code is wrong. It's actually

create NONCLUSTERED INDEX #idx_ID on #ID(ID) include (TID).

But I will run it again without index portion.

I an using following sql code in OLE...

When I run stored proc on ssms, it runs fine. Problem occurs when I try to execute the store proc in SSIS package.

Stored Proc is being used...

Thank you! Putting the money aside, that's what I was thinking.

Thank you all for your kind advice.

One company is very small organization, the other is big. When i think about money, its no brainer. But if what my mis dirctor saying is true, i...

Thanks for your kind feedback!

Good point on product dimension.

Before I post my another updated design of DW, I would like to ask some question.

My sales manager wants...

Yes, we could easily utilize reporting service to create reports and simple dashboard. But before we deploy something more complex (Sales DW), I wanted start it off with small and...

Thank you SSCrazy for your input!

1. I think you are right on Type 2 SCD for Customer Location.

2. While I am only required to capture sales data for...

Thanks for your kind suggestion.

After going over your comments, and I made some changes to my DW:

DimSalesPerson

- Sales Person Key

- Sales Person Name

- Start Date

- End Date

- Active

- Years Employed

DimCustomer

-...

Thanks for your input!

Is there anyway I can do this trigger? Our report database is read only and I can't create any view or trigger 🙁

Thank you for your input sir!

Thanks Raunak Jhawar. I didn't list any reference between fact table and dimension. As for the two different fact table, I think you are right :). So...