Skip to content

Business Intelligence Tech Tips

ETL, Report Design, DB, Architecture and more

  • About

Month: December 2019

Lessons from migrating Oracle to Redshift – Data types

On December 21, 2019December 24, 2020 By bitipsblogIn Uncategorized3 Comments

This post is a first in a set of posts, which discuss various lessons learned from migrating a BI infrastructure from Oracle to Redshift

This particular post discusses the migration of Oracle data types to Redshift, obstacles, tips and some important function usage differences

Continue reading “Lessons from migrating Oracle to Redshift – Data types” →

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