My Requirement is:

I have a OLTP database, using this i should create a dimensional model (Star or Snowflake schema). Using this model i should give some reports using SSRS.

NOTE: Cube...

Hi,

I am using Microsoft BI (SSAS, SSIS and SSRS) software for thie above requirement.

Srinadh.

But the performance is the key here. Other than BCP any alternative?

May be 1.5lacs and that too we should not use IMPORT and EXPORT wizard.

Hi Srikant,

For the Department "D1", there are 5 dynamic columns. If you see the below O/P you can have an idea on this: For the remaining there will be only...

Hi,

Thanks for your suggestion and i will practice myself.

Thanks to all

Srinadh

I told my experiences. I am not saying that what ever i told was correct. But i want to know, how people will do the thing like he asked. If...