Search


	Podcast:		voiceofthedba's podcast
	Episode:		ETL or ELT
	Category:		Technology
	Duration:		00:03:11
	Publish Date:		2018-04-02 20:00:00
	Description:		I was reading a piece on ETL patterns and found it interesting that the author noted that one way to reduce the challenge of ETL processes keeping up with changing schemas is to move to an ELT process. That's an interesting perspective, and I wonder what those who work with the relational model think. IS this a pattern you like? In a traditional ETL pattern, we get data from a source (Extract), manipulate it to suit the target schema (Transform) and then Load it into the target. The hassles here, and the reason this is hard, is that the transformations are often complex. We deal with ragged rows, various delimiters and terminators, and more. Lots of consultants have made quite a bit of money by building these transformational applications and processes and maintaining them as requirements change. Read the rest of ETL or ELT
	Total Play:		0