Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Schema question for multiple fact tables
Rather than tracking sales at the pageview level, I'd track it at a session level. Aggregate your pageview data at a session granularity and then you can either create a view over your session data and sales data to show sessions that have sales ("converted sessions") or create another...- dwa007
- Post #11
- Forum: Data Warehousing/Big Data
-
ETL Process for Clickstream Analysis
In case your "out of the box" solution doesn't do everything you need, you might want to consider writing your ETL in Perl. Perl has excellent support for pattern matching. Our clickstream data mart uses Perl to extract data out of the weblogs and load in to an Oracle 10g database.- dwa007
- Post #8
- Forum: Data Warehousing/Big Data
