Q: We have three data sources that are feeding three different stars. We wrote stored procedures in the ETL layer to load them. Also we need to join them in the detail level to calculate certain figures based on information that exists in these three data types. Shall we do this while loading with all the delay this may cause, or shall we load them, then run joining scripts and calculate these figures with the synchronization and delay issues? The same joining between these three sources is used for revenue assurance.

My advice is to run stored procedures or scripts after the stars have been loaded. Some of these calculations can be complex and may take up more time than you can afford. Also, since your revenue assurance is done this way, there is been precedent on using this approach for critical processes.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access