Extract, Transform and Load (ETL)
My day to day job is all about ETL . Currently i need to load a full refresh data from AS400 source system into Data Warehouse system in SQL Server.
Basically,you can imagine how this works using below diagram.
source: http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=89534
For all these, im using ADT. For me,ADT is a powerful CA product. Using it, you can move your data from any source to anywhere,anytime and the most important thing is, it’s very easy to use. 
Below is a simple transformation that we can do.
Well,that’s for introduction.
Till then…
If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !
ini ek kije ko .. heheh.. ok lah tu
.. aku tatau apa kebenda yang ko duk citer tu .. anyway thanks .. ada benda baru aku blaja ari nih ehehe
ehee…iniler kejer aku sekarang gerg.since 2002 lagi.semua main drag and drop jer. ada sket2 jer programming.
ehhee kira nya db admin laa ni ek?
tak juga gerg.
tapi more on datawarehouse punya stuff lar.
[...] BI is about extracting,transforming and loading information from multiple sources of data. [...]
[...] Company for quite some time. Since 2001 to be exact. ETL is part of data warehouse component. My Introduction post about ETL is somewhere in 2006. Since then, so many things happened. I resign and come back again to the same [...]
[...] Data Integration (PDI) is a powerful, metadata-driven ETL tool designed to bridge the gap between business and IT; Previously it’s known as Kettle [...]