BIAnalytix Question: Ensure daily loads to the warehouse

 How are job dependencies managed, for example, how does BIAnalytix ensure daily loads to the warehouse do not begin until staging table load is completed?

Answer:
The data warehouse must be loaded sequentially by date so it is always waiting for a particular date of staging data per source with a 5 minute check loop. When this date’s data is in the staging table for any source, that source ETL processing starts. When all sources are loaded or abandoned, the integrated OLAP cube process starts, again by checking the status of all sources.

© Copyright 2011, Decentrix Inc. All rights reserved.
Decentrix Inc. 1200 17th Street, Suite 200, Denver, Colorado, 80202 Phone: 303-899-4000  
 
 Decentrix Website Solution & Collaborative Intranet Tools   |   DishOnTheWeb.com by Decentrix, Dish Network Retailer Solutions
Afftraq Affiliate Sales Tracking Solution   |  HotDesk, Superior Website & Intranets for Small to Medium Size Business

Home Products Website Solution Collaboration NetAnalytix e-Commerce Technology Overview Architecture Quickcentrix Quickcentrix Integration Kit Consulting Web Analytics Consulting e-Commerce Consulting Business Intelligence Analytics Decentrix Process Online Marketing Site Visitors Search Engines Register With Yahoo Register With Google Search Engine Ranking Becoming Visible Online Collecting Prospect Lists Checklist Target Market Tours Website Solution Tour Collaboration Tour NetAnalytix Tour BIAnalytix Tour Clients News Press Releases e-Newsletters Contact Support Sales Company Vision Management Team Careers