ETL is an acronym for Extracting, Transforming and Loading data into a data warehouse or any other database or application that houses data. Taking the data transfer process to a higher level, Microsoft has patented its Structured Query Language (SQL) Server Integration Services (SSIS). SSIS is a platform for building high performance data integration solutions, subsuming ETL packages for data warehousing.
Triple Constraints of Project Management
Project success greatly depends on whether or not constraints set for project are satisfied. The triple constraints of project management are Scope, Time and Cost. A project with time constraints can be called successful if project is delivered within specified time. Similarly projects with scope or cost constraint will be called successful projects if scope or cost constraints are satisfied respectively.Slowly Changing Dimensions and Date Chaining
Attributes that experience changes once in a while are called slowly changing dimensions. Date type attributes that need to be updated while saving previous records, are managed using the concept of date chaining.What is XML Technology
XML stands for Extensible Markup Language. The name extensible comes from the fact that users can create unlimited number of tags and reuse those tags; where as the name mark-up is because of XML"ýýs simple approach to structure data that is by using descriptive labels. It was derived from SGML (Standard Generalized Mark-up language) mainly for more manageable data storage and transportation.