‘Data Transformation’ Archives
in this video: demonstates extracting data from excel files dynamically using SSIS. also demonstrates how to make connection managers and other properties dynamic.
A Glossary of Terms by Brian Marshall * Data Quality * Data Quality Domain * Data Quality Rule * Data Profiling * Data Quality Profiling * Database Profiling Data Quality is a measure of the value of data in relation to potential data problems: * missing data records or data [...]
This post is about "traditional approaches" a title we found in MSDN for data cleansing. We are including this in our website because we use various methods for data cleansing. For experienced professionals there is hard and fast rule because of task on hand requirement. But a traditional approach title is included in datamart.org to identify [...]
Data scrubbing also called data cleansing, is the process of amending or removing incorrect data in a database. Sometimes data incomplete, improperly formatted like postal code should be in this format "N9B 1W7" not in “N9B1W7"or first name and last name in 1 field, instead separate fields or duplicated. Sometimes zip codes are missing or in [...]
Many times in the job descrition a title Data Architect is used. According to DAMA (Data Management Association) , Data Architect is often interchangeable with, but includes enterprise architecture considerations. A DAMA recognized Certified Data Management Professional would have a wide range of such skills. Translating this to Data [...]
1- Operational databases are design to remove redundancy, accurate updates and removal of repetitive operations for example deposits, flight reservation. Business intelligence has the goal of business reporting and data analyses. 2- Operational data bases are highly normalized in relational database [...]
Source: SQL Server 2008 Books Online (May 2009) Proactive caching provides automatic MOLAP cache creation and management for OLAP objects. The cubes immediately incorporate changes that are made to the data in the database, based upon notifications received from the database. The goal of proactive caching is to provide the performance of [...]
We have initiated a web database where important business and government conacts of all all countries are searchable at WorldOnline.biz We are working on this database and adding more information on different angles. However at present there are about nearly 10,000 contacts are added and are searchable.
As we are driven by the goal making information technology understandable by business decision makers and end-users, therefore when ever we find any simple word made unnecessarily technical term, we made best efforts to make them original / understandable. So Legacy database is a group of heterogeneous data bases that combines different kind of [...]
Latency is defined as the time of occurance of a transaction and loading of that transaction's information in Business Intelligence system. It depend on the task of Business managers some time they need to see measures daily level for example daily poduction quantity, weekly production to compare with there poject requirements Sometime decision [...]