Monthly Archives: June 2011

Convert the data type of an incoming data – Data conversion task – SSIS

Posted on June 30, 2011 by

Data is stored in different location and in different formats and types. It depends of the nature of the application wherein data is stored in different data types. We have two standard types of data Numeric and Alpha-Numeric. For instance, … Continue reading →

Posted in SSIS | Tagged , , , , , | Leave a comment

Multiple data aggregation using single dataset

Posted on June 29, 2011 by

Aggregation is a process of calculating data such as sum, average, min, max, etc. It as another name in reporting environment called summary table. Pre-aggregated data is stored in a temporary or permanent table to serve for the summary reports. … Continue reading →

Posted in SSIS | Tagged , , , , | Leave a comment

Lookup Transformation

Posted on June 28, 2011 by

Searching a reference key value to fetch the related data from another dataset is a common database manipulation. Lookup Transformation Lookup Transformation task lookups input column with the reference dataset. Lookup transformation needs separate datasource connection. It may be a ole … Continue reading →

Posted in SSIS | Tagged , , | Leave a comment

Get your data from cache – Cache Transform task – SSIS

Posted on June 27, 2011 by

Cache is a component that stores data and helps the system to serve the stored data from the cache instead disk. It is more powerful component in the system with high performance read and write operation. Cache improves performance of an … Continue reading →

Posted in SSIS | Tagged , , , , , , , , , | Leave a comment

Create multiple dataset from single datasource

Posted on June 26, 2011 by

Duplication is a very common term in data warehouse environment. We may call it as redundant data. During data transformation process we may need a  dataset for multiple requirements. To do so, we create multiple copy of a dataset from … Continue reading →

Posted in SSIS | Tagged , , , | 2 Comments