Data Integration

1 - Term

  • ETL : Extraction, Transformation and Load Software
  • ELT : Extraction, Load and Transformation Software
  • Do it once at night vs. do it every time for a query
  • The “360 degree view of the enterprise” is a commonly discussed goal that really means data integration.

2 - Performance Note

A full Data Vault loading cycle might take 40 or 50 minutes total time, (50 staging tables, 1 terabyte incomming data) – where a so-called “traditional” (type 2 dimension + facts) loading cycle for the same data sets would take about 3 to 4 hours…. It can all happen in PARALLEL…

3 - Information Managment

4 - Magic Quadrant

  • Bookmark "Data Integration" at del.icio.us
  • Bookmark "Data Integration" at Digg
  • Bookmark "Data Integration" at Ask
  • Bookmark "Data Integration" at Google
  • Bookmark "Data Integration" at StumbleUpon
  • Bookmark "Data Integration" at Technorati
  • Bookmark "Data Integration" at Live Bookmarks
  • Bookmark "Data Integration" at Yahoo! Myweb
  • Bookmark "Data Integration" at Facebook
  • Bookmark "Data Integration" at Yahoo! Bookmarks
  • Bookmark "Data Integration" at Twitter
  • Bookmark "Data Integration" at myAOL
dit/dit.txt · Last modified: 2016/06/07 10:34 by gerardnico