Showing posts with label Table Partitioning in warehouse database.. Show all posts
Showing posts with label Table Partitioning in warehouse database.. Show all posts

Friday, May 3, 2013

[SQL Server Data Warehousing] Table Partitioning in warehouse database.


Hi Experts,


Migrating warehouse from Oracle to SQL Server :
Status: In process


In Oracle : 6 Schemas
In SQL Server:  Created a database with 6 Schemas.


-Every Schema has 3 Paritioned and 3 non partitioned tables.
-Out of 3 partitioned tables one is parent table and all other 5 tables are child tables.
-Only parent table has date column and non other table has date column for partitioning.
-all the 5 tables in each schema has primary key.



My Question is can I partition parent table with date column and child tables with Primary key column ?


If so please can someone advise the partitioning method for a parent table and child tables.


sometimes the partitioning column in parent table has abnormal dates like 2099,2088. How can i seperate those values. I listened that we can do by MAX and MIN dates while partitioning but not sure how to implement that..



Thanks for all your time.



.

social.technet.microsoft.com/Forums

Wednesday, May 1, 2013

[SQL Server Data Warehousing] Table Partitioning in warehouse database.


Hi Experts,


Migrating warehouse from Oracle to SQL Server :
Status: In process


In Oracle : 6 Schemas
In SQL Server:  Created a database with 6 Schemas.


-Every Schema has 3 Paritioned and 3 non partitioned tables.
-Out of 3 partitioned tables one is parent table and all other 5 tables are child tables.
-Only parent table has date column and non other table has date column for partitioning.
-all the 5 tables in each schema has primary key.



My Question is can I partition parent table with date column and child tables with Primary key column ?


If so please can someone advise the partitioning method for a parent table and child tables.


sometimes the partitioning column in parent table has abnormal dates like 2099,2088. How can i seperate those values. I listened that we can do by MAX and MIN dates while partitioning but not sure how to implement that..



Thanks for all your time.



.

social.technet.microsoft.com/Forums

Search This Blog