Data Integration

SQL Server Data IS profiles stored in tables

8

The task of SQL Server Data Profile Information Services stores the results of profiling in an XML document that can be examined with the Data Profile Viewer. In the article SQL Server 2008 Dataprofiling to explain how to use this new Task in SSIS. Although this method is very simple

Informatica 9, a complete data integration platform

0

In the market for data integration one of the leading manufacturers is Informatica. This company is the leading independent provider of data integration software.

Business Intelligence Forum 2010

6

On Wednesday May 12 celebrated the 10th Forum of Business Intelligence, which has been Dataprix Media Partner and I had the opportunity to attend.

The event was quite interesting, and it was a good opportunity to learn first-hand opinions and impressions of deployments responsible for business intelligence projects.

I find it very appropriate that most of the interventions were responsible for the area of IT or business data warehouse, as the vision and how to communicate to the person who runs a project internally is often the most realistic and that can best explain the needs, problems and what actually can be considered at the level of business success or failure of a technology project.

 

Informatica 9, a complete data integration platform

5.66667

In the market for a Data Integration is a leading manufacturer Informatica. This company is the first independent provider of data integration software. His best-known tool and the heart of his platform is Informatica PowerCenter, which has gone through many versions, and is a reference in the world of integration.

But apart from PowerCenter, Informatica also has other tools that focus on more specific purposes, while that are integrated into the platform, and always in the context of Data Integration.

Data Warehouse Architecture: data areas of our Corporate Data Warehouse

7

Areas de datos para la carga de un Data WarehouseWhen designing the architecture of a data warehouse system we have to raise different environments for which data must pass en route to its Data mart or target cube. Given the amount of changes that have to do, and normally the DWH, besides fulfilling its function of support analytical
requirements, performs a data integration function that will form the Corporate store and they will have to be also consulted the traditional way by the operational systems, it is recommended to create different data areas in the path between source systems and OLAP tools.

Each of these areas as characterized by the functions performed, how data is organized in the same, and what type of need can service. The area that is 'at the end of the road' is important, but it will not be the only store data that will exploit the reporting tools...

Syndicate content