Skip to content

Notes and Random Stuff

reminders and code snippets

Monthly Archives: November 2014

ETL Transforms: some basic techniques

Some basic principles: Select your indexes and sortable columns wisely, it can be the difference between hours and seconds runs Try to process your data in chunks, create a staging table where you do your transforms with smaller amounts of data, instead of transforming all the data at all times. Try to batch the changes […]

Posted byonsubjec-adminNovember 6, 2014Posted indatabasesTags: databasesLeave a comment on ETL Transforms: some basic techniques

Recent Posts

  • React.js: the basics
  • Redshift: alter table column TYPE is not allowed
  • firebase setup
  • AWS lambda: the basics
  • Atom: the basics

Recent Comments

  • Larry on HTML role attributes
  • grindking on HTML role attributes
  • admin on Backbone.js: event aggregation and AMD
  • Randy on Backbone.js: event aggregation and AMD
  • jack on Ruby On Rails: utilities and console commands

Archives

  • March 2019
  • August 2017
  • July 2016
  • June 2016
  • May 2016
  • February 2016
  • January 2016
  • November 2015
  • July 2015
  • June 2015
  • May 2015
  • March 2015
  • February 2015
  • November 2014
  • August 2014
  • June 2014
  • May 2014
  • January 2014
  • December 2013
  • October 2013
  • September 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • January 2012
  • December 2011
  • November 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • August 2010
  • June 2010
  • May 2010
  • January 2010
  • December 2009

Categories

  • Angular.js
  • apache
  • API
  • Atom
  • AWS
  • backbone.js
  • bootstrap
  • Canvas
  • Compatibility issues
  • Contracting
  • CSS
  • CSS3
  • Cucumber
  • databases
  • devops
  • Docker
  • Encoding
  • ES6
  • express
  • Facebook
  • firebase
  • Fonts
  • General
  • Git
  • Google
  • Gulp
  • Heroku
  • HTML
  • HTML Templates
  • HTML5
  • Icons
  • IE7
  • Images
  • impact.js
  • Ionic
  • IOS
  • iphone
  • JavaScript
  • JavaScript Effects Index
  • Jquery
  • jquery mobile
  • Linux
  • Mobile
  • mongodb
  • mysql
  • node.js
  • phonegap
  • PHP
  • Programming
  • Python
  • Rails
  • react.js
  • redshift
  • Resolution
  • Responsive Web Design (RWD)
  • rspec
  • Ruby
  • sass
  • selenium
  • SEO
  • SSH
  • Statistics
  • SVN
  • testing
  • Tools
  • Ubuntu
  • Uncategorized
  • Vagrant
  • Videos
  • Web optimization
  • Web Servers
  • Wordpress

Meta

  • Log in
  • Entries RSS
  • Comments RSS
  • WordPress.org
Notes and Random Stuff, Proudly powered by WordPress.