Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Datawahouse Split

Datawahouse Split

Datawahouse Split

Hi All,

     We are currently working for a company that has split into two. We have been asked to seperate the data from the warehouse between these 2 companies. Wanted to know the approaches for separating Master Data (Master data is both shared and exclusive to the respective company), aggregated data.  Pointers to any material which talks about splitting datawarehouse data in a company spin-off situation is greatly appreciated.


RE: Datawahouse Split

I don't have any experience in this but a couple of things come to mind.

The split can mean two things,
1. Horizontal split, i.e. split the data while keeping the formats and standards for Metadata and Master Data.

2. Vertical split, i.e. functionality split where one of the spin off gets a set of subject area and other mutually exclusive set.

Chances are it will it will be hybrid approach, meaning some of the some of the subject areas will be split horizontally while others will be exclusively assigned to one of the two organizations.

Are you or your group responsible for maintaining MDM integrity for both?


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close