BIAnalytix Question: Complex transformation processes

 What is one of the BIAnalytix more complex transformation processes?

Answer:
The longest running step of the ETL transformations is the Left and Right Outer Join of the Staging spots with the Fact Spots over every column to detect both reversals and insertions for the data warehouse. The most complex transformation is to detect the changes in the Many-to-Many group membership of spots and breaks related to overlapping sales period avails.

© 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