Skip to content

Business Intelligence Tech Tips

ETL, Report Design, DB, Architecture and more

  • About

Tag: ETL

Redshift with SAP Data Services

On January 19, 2018January 23, 2018 By bitipsblogIn ETL, SAP Data ServicesLeave a comment

Redshift is a supported source & target for SAP Data Services 4.2 SP8. However, there isn’t much information available about utilizing Redshift with the use of SAP Data Services. Therefore, I decided to summarize my recent observations related to this subject.

Continue reading “Redshift with SAP Data Services” →

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

  • 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
  • Gathering DB Statistics during ETL

Recent Comments

bitipsblog on Lessons from migrating Oracle…
Anoop on Lessons from migrating Oracle…
bitipsblog on Comparing Resources & Perf…
Scott on Comparing Resources & Perf…
Utilizing Oracle Bas… on Creating a calendar dimension…

Archives

  • 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

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Recent Posts

  • 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
  • Gathering DB Statistics during ETL

Recent Comments

bitipsblog on Lessons from migrating Oracle…
Anoop on Lessons from migrating Oracle…
bitipsblog on Comparing Resources & Perf…
Scott on Comparing Resources & Perf…
Utilizing Oracle Bas… on Creating a calendar dimension…

Archives

  • 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

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