Skip to content

Business Intelligence Tech Tips

ETL, Report Design, DB, Architecture and more

  • About

Tag: DB

Gathering DB Statistics during ETL

On May 19, 2017May 19, 2017 By bitipsblogIn ETLLeave a comment

Gathering table statistics can have severe performance implications for your ETL & reporting process. In this post I describe why it is important to consider gathering statistics in your ETL process and I provide an example of how this can be achieved.

Continue reading “Gathering DB Statistics during ETL” →

Recent Posts

  • Unravel Tableau Workbook Structure (TWB/TWBX)
  • Lessons from migrating Oracle to Redshift – Data types
  • Dynamic RegExp pattern matching in Redshift
  • HTML based emails from Python (ssmtp)
  • Redshift with SAP Data Services

Recent Comments

Devesh Kumar's avatarDevesh Kumar on Lessons from migrating Oracle…
bitipsblog's avatarbitipsblog on Lessons from migrating Oracle…
Anoop's avatarAnoop on Lessons from migrating Oracle…
bitipsblog's avatarbitipsblog on Comparing Resources & Perf…
Scott's avatarScott on Comparing Resources & Perf…

Archives

  • September 2023
  • December 2019
  • September 2018
  • January 2018
  • May 2017
  • November 2016
  • October 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015

Categories

  • ETL
  • Reporting
  • SAP Data Services
  • Tableau
  • Uncategorized

Meta

  • Create account
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Recent Posts

  • Unravel Tableau Workbook Structure (TWB/TWBX)
  • Lessons from migrating Oracle to Redshift – Data types
  • Dynamic RegExp pattern matching in Redshift
  • HTML based emails from Python (ssmtp)
  • Redshift with SAP Data Services

Recent Comments

Devesh Kumar's avatarDevesh Kumar on Lessons from migrating Oracle…
bitipsblog's avatarbitipsblog on Lessons from migrating Oracle…
Anoop's avatarAnoop on Lessons from migrating Oracle…
bitipsblog's avatarbitipsblog on Comparing Resources & Perf…
Scott's avatarScott on Comparing Resources & Perf…

Archives

  • September 2023
  • December 2019
  • September 2018
  • January 2018
  • May 2017
  • November 2016
  • October 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015

Categories

  • ETL
  • Reporting
  • SAP Data Services
  • Tableau
  • Uncategorized

Meta

  • Create account
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
Blog at WordPress.com.
  • Subscribe Subscribed
    • Business Intelligence Tech Tips
    • Already have a WordPress.com account? Log in now.
    • Business Intelligence Tech Tips
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar