In 1996 Building ETL Processes is ChildsplayI started building ETL processes in the SAS System for a customer. This Customer needed a metadata driven approach for their Data Warehouse solution.
We build a nice collection of datasets / tables which contained the metadata about the source, the target and the transformations. This was my very first encounter with metadata drive ETL processes. There was no tool at that time like Informatica PowerCenter, Microsoft SSAS and SAS Data Integrator. All was built in pure macro code which accessed the metadata and created code on the fly.
Now 12 years later, I am again involved in building a metadata drive ETL factory, which can be configured and driven by non-technical people. We now-a-days have nice tools that can help these people in their job of building and configuring ETL processes. The only problem is that the out-of-the-box solutions which are provide never are suffient for the person needs.
For me this behaviour of the people and market has led to a first attempt to write an article about how child toys can be used to visualise the needs for ETL processes. You might call me the LEGO / DUPLO man, because multiple customers already heard my story about these childrens toys and how this affects their ETL processes they are building.
I hope I will be able to show the article on this BLOG soon (I will be starting an ARTICLE WRITING COURSE this month), until that time enjoy the YOUTUBE video below. This is an other visualisation of what can be done with LEGO !!!
Dutch JUMP Style
An other Dutch Jump Style
Last but not least, a link…
http://ldd.lego.com/






















Posted in
Tags: 




Also nice LEGO stuff:
http://www.telegraaf.nl/buitenland/3163702/_Keiharde_Lego-porno__.html?p=14,2
Hi, I suppose you mean SSIS in stead of SSAS. SSIS is used to build ETL flows, SSAS is the OLAP solution.
BTW, nice to see a Dutch BI blog!
Regards,
Stan.
Stan, you’re absolutly right about that. My mistake, point taken !!!
wow !!
its very reasonable point of view.
Good post.
realy gj
thank you
You know,
XRumer 5.0 is the BEST OF BEST program for S.E.O. and S.E.O.
Increase Google Page Rank, make income traffic and money, got customers and bucks
More info?
Just GOOGLE for XRUMER 5.0!
Good luck
Hello all, just want to say I great place to learn. I have to post some good info very soon
[...] intelligence easier by using the metaphores of children and their mindset (see earlier posts : Building ETL is childsplay) AKPC_IDS += "188,";Popularity: unranked [?]Bookmark to: « Twitter is HACKED [...]
Hola,
wisdom.smetser5.nl – da mejor. Guardar va!
Socco