Artículos IT, información y publicaciones sobre ETL

Últimas publicaciones destacadas en Dataprix sobre esta temática TIC

Do we give the importance they deserve to Data Quality Processes?

Average: 4.5 (1 vote)

Perfilado de datos. Estadísticas y distribuciones de datosAmong the Data Management activities that organizations performs the processes that monitor and ensure data quality are becoming critical. The volume of information is constantly growing in organizations. Having a reliable data storage is essential for a correct analysis and explotation of these data, avoiding inconsistencies, misleadings and facilitating the development of future systems based on master data consistent, cleansed, enriched and reliable.

Business Intelligence Forum 2010

Average: 3 (1 vote)

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

Average: 3 (3 votes)

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

Average: 2.9 (4 votes)

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

Datacleansing with Oracle Warehouse Builder

Average: 3 (1 vote)

In the link Managing Dates Quality can be agreed to an article of Ron Hardman on how carry out data cleaning processes with Oracle Warehouse Builder.

The article begins with an introduction to the quality of the data and ways to negotiate it, being one of them the utilization of the data cleaning options of Oracle Warehouse Builder.

The interesting thing is that is shown how to discharge a script with data of test, and how to configure the tool to test the utilities of Profiling, definition of Rules (Dates Rules), and correction or cleaning of the data. In this manner can be seen and to test in a simple way how to implement a basic process of Dates Cleansing with this tool.

The original article is in English but seeking in the web of Oracle I have found the 3 documents that enclosed, translated the Spaniard, and related to OWB and the cleaning of data:

  • Executive report - Oracle Warehouse Builder 11g Version 1 General Information
  • Oracle Warehouse Builder Dates Quality Option
  • Oracle Warehouse Builder Enterprise ETL Option
Syndicate content