[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