Creating New Subject Areas in Warehouse from Fusion, NetSuite, Salesforce, Eloqua Sources

Vikas Agrawal

It is a comlex undertaking to create new subject areas within the warehouse as it requires knowledge of the domain. We propose to lay the foundation for creating such subject areas by the following approach:

1. Create Mapping from Subject Areas to HRFs to Source Data to Extract the Structure and Minimal Constitution of Each Existing Subject Area, Creating a Relationship Graph Between the Entities Involved.
2. Then Use Knowledge from Documentation and Well-known Book Chapters on the Subject Area to Enrich the Mapping and Graph Above with the Documentation and Real World Books it Correlates With
3. Now Start from the Book Chapters or Description of a New Subject Area, and then Find the Related tables/columns from the source datasets, validate the relationships, and create the warehouse tables and columns for the subject area.