Sunday November 19th 2017

Categories

Insider

Archives

‘Data Transformation’ Archives

Reading data from multiple Excel files dynamically using SSIS

Reading data from multiple Excel files dynamically using SSIS

in this video: demonstates extracting data from excel files dynamically using SSIS. also demonstrates how to make connection managers and other properties dynamic.

Data Quality and Data Profiling

Data Quality and Data Profiling

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 [...]

Traditional Approaches Of Data Cleansing

Traditional Approaches Of Data Cleansing

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 / Cleansing

Data Scrubbing / Cleansing

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 [...]

Data Architect – Overview

Data Architect – Overview

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 [...]

Difference between operational databases and Business Intelligence

Difference between operational databases and Business Intelligence

          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 [...]

Proactive Caching (Dimensions)

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 [...]

World’s Business contacts Database by Datamart.org

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.

Heterogeneous Databases and Legacy Databases

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 IN Business Intelligence

Latency IN Business Intelligence

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 [...]

 Page 1 of 3  1  2  3 »