ETL Tools enable extract transform and load data from operational source systems into Data Warehouse for decision making. ETL tools automate many complex T-SQL scripts. Apart from automating T-SQL scripts, ETL tools also offer parallel processing, auditing, error handling, and logging systems which can be configured easily. Also the deployment and maintenance of ETL is easier compared to maintenance of T-SQL scripts. ETL Tools are very powerful and they offer many advantages in all stages of ETL process starting from extraction data cleansing data profiling transformation debugging and loading into data warehouse when compared to the old method.
Friday, July 30, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment