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

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

Introduction to Open Data, Linked Data, data and resource catalogs

Average: 4 (1 vote)

Mapa de catálogos de datos Open Data en EspañaOpen Data is a movement that is meant to make easily accessible to citizens and businesses that collect public government data.

Open Data is supported by the W3C and other international bodies, and gradually adds up initiatives in different countries. The first step is the initiative of a public body, was made publicly available certain information in one or more standard formats easily 'treatable'. Since there may be other agencies or businesses that add value to that data across or enriching them with other data sources, or developing applications that allow user to see that data in a friendly environment.

 

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

The suites of Oracle Business Intelligence

Average: 3 (1 vote)
Cuadros de mando de Oracle AnswersOracle, in addition to their famous manager database has a large catalog of software products, many developed internally and acquired through the purchase of other companies.  Within the environment of business intelligence that fact is even more remarkable as just more of Oracle's recent acquisitions were purchases of BI software vendors.
 
The result is that although each tool has some features and a more appropriate market, there are many overlaps, and costs a little lie when choosing what software or set of tools we could use for our business intelligence project...

Data Profiles of SQL Server Information Services stored in tables

Average: 4 (3 votes)

The task Data Profile of SQL Server Information Services stores the results of profiling in an XML document that can be examined with the Data Profile Viewer. Article Dataprofiling with SQL Server 2008 explains how to use this new Task in SSIS.

Although this method is very simple, sometimes may not be sufficient. Addressing a data quality project may involve, for example, storing a history of profiles to assess how data quality of processed data has been improving.

The best way to work with historical data is using a database and storing the data in tables, where you can make queries, reports and comparisons. To achieve that all you would need to do is moving the metadata that the profiling task has been storing in the XML file to database tables.

Well, someone has already prepared an easy way to do it. Thomas Frisendal from the website Information Quality Solutions explains how to create an XSLT file for each type of profiling that is used to extract the XML generated by the Data Profile Task SSIS into one or more XML files with a format that can be directly imported to tables .  

The error ORA-30926 as a result of a Merge

Average: 3.3 (4 votes)

ORA-30926 error usually occurs when performing merge operations, and typically we leave something descolocados as the description of it does not give too much information about what is happening: 
ORA-30926: unable to get a stable set of rows in the source tables.

Normally this error occurs when the merge operation to target a row to be updated on it more than one row in the table source. As the engine does not know what to choose register returns an error. It is a problem of duplication in the origin table.

Example:

  • We have: 
    TABLA_ORIGEN with the values 
    ID Description 
    1 'The first value' 
    1 'The value with duplicate id' 
    2 'Another value'

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

Tools for implementation of a Data Warehouse

Average: 3 (1 vote)

There are many different companies that offer tools for the creation and operation of a Data Warehouse.
When it offers a complete suite, which covers the creation of the database to exploit the same for different profiles and targets, often seen as tools for Business Intelligence.
  • The Data Warehouse is implemented on a system provided database manager, and loads of data that are made on it from different backgrounds can use ETL tools, which allow to link the database with different origins, define transformations to be done for the integration of data, and schedule or automate regular loads. 
  • For operations using different tools, which can be classified according to the profile of the person who uses them.
    • The classic reporting tools are for users of different departments that need to operate in their daily work specific information.
Syndicate content