Then I leave a series of reviews I've done over the same, feel free to select / read / the most preferred:
1) Small overview: I found a very interesting book, easy to read and understand, with the necessary explanations, many examples pr & aacute; ICTC and many screenshots.
Ideal for insight into the tool and start making our own solutions.
2) Review from the user point of view of Pentaho, the book takes a stroll around the tool, describing and illustrating in each case, the purposes and functions.
Among the most important, this book tells and illustrates:
- what is the layout of the tool and what each part of it.
- how to use and how to configure your workspace.
- how they should use different bands within the workspace.
- how to make connections to our originss data, using: JDBC, metadata, pentaho data integration, OLAP, XML, etc.
- how to insert functions and what each one.
I set aside a time series of tutorials that I have been developing since I remembered to have done several before and wanted to share. I had to touch them up a bit, but have been well. Had used to give to students in subjects that I taught last year.
This video tutorial (this is one video) will go up into 3 posts to avoid problems, it is creating a web application on Apache Tomcat 5.5 using Eclipse with JBossTools 3.0 , the application is created based on the MVC patternand implemented using Apache Struts .
We'll see how to create a new project, lay out and implement the required artifacts (Form Beans, Actions, JSP, resources, etc.) and how to internationalize the components.
You will not see anything about theory and how the Struts framework, for this I recommend reading this book free .
Clarified that this video tutorial does not have audio, I've added music to my taste in the background, who share the pleasure, or just want silence, they are free to press mute.
This video will undertake the following actions:
* Populate database "practical."
Mariano García Mattio
We have been more than three years talking about Cloud Computing and, far from diminishing its presence in the media, it is growing. No doubt this is a good sign for this concept, which seems to represent the new paradigm of information technology.
The concept itself is very close to us and, most of us use everyday. Gmail, Flickr, or Dropbox GoogleDocs are just some examples of a multitude of applications and services that reside in the cloud computing. The Cloud Computing is not a technological invention, but the natural evolution of the Internet. This network of networks that consists of millions of computers connected to each other, finally seems to have learned to use this networking and the computing power to offer its own interior give the same services formerly offered des stations work and currently offered for enterprise servers.We see this same trend in other sectors or types of services such as electrical supply or parcel services.
The technology to support the value chain of any company, including back office solutions (administrative, financial and logistics), solutionstions front office (customer service by phone, POS, Mobile Sales Force), plus its own solutions for their sector of industry (tailored, niche solutions).
How to deal with this map of solutions? The key word is "integration", which is given by platforms such as SAP, Oracle, Microsoft, which in most cassis offer a suite of products that minimize the cost of integrating the different types of technology.
In the case of SMEs, the budget for the technology area, increases the difficulty of achieving integration novices.
Another important feature that should have a DWH is being "organized by topic" (subject-oriented). Bill Inmon is considered one of the fathers of the concept DWH, and it was he who introduced this feature in its definition:
"A warehouse is a subject-oriented, Integrated, time-variant and non-volatile collection of data in support of Managements decision making process" (Bill Inmon, 1990)
The thematic organization of the information refers to data that are loaded include the relevant indicators in different areas of company information.They should be able to cross the indicators relating to the same object or event the real world.
This thematic organization of information facilitates the subsequent construction of ad-hoc reports, as it allows and across information that was generated in very different business processes (even on the same topic).
We will develop processes to load the fact table sales of our project using Talend. Before this, we will make some considerations about the frequency of load processes will allow us to introduce the use of a new element of Talend, contexts.
In principle, we will have several types of data load:
- Initial charge: be the first to be made for the implementation of the project, and will include the dumping of the sales data from an initial date (to be selected in the process) until an end date.
- Loads week: the type of load is more immediate. Is performed for each week (eg Tuesday of each week is charging the previous week) to take a first step information from the previous week (later to consolidate the data refresh end of that period) .The burden of a given week will also be performed on demand (outside the automatic batch process).
- Top-monthly: once you close a monthly period (which implies that there can be no changes to this period), cools the entire month in the DW to consolidate the information and give the final status for that period. The execution is to request and indicate the time period you want to process.
One of the many improvements brought about SQL Server 2008 on the ETL with Integration Services is its ability to perform data profiling with its new Data Profile Task.
The profiling data is one of the first tasks that typically addressed in data quality processes, and involves an initial analysis of the source data, usually on tables, with the aim of getting to know its structure, format and level quality. Inquiries are made at the table, column, columns, relationships, and even relationships between tables.
The Data Profile Task SSIS works by selecting a table in a SQLServer 2000 database or above (no use other databases), the profiling options you want to perform on the data table and an XML file can be stored the results when running the same.It's really simple.
You can select up to 8 types of profiling, 5 to level 3 to level column and multiple columns.
The event had as main thread presenting this new version of IBM Cognos, but also included broader sessions, with topics such as corporate performance management, analysis, 'What-if' and other arrangements under financial, Business Insight and predictive analytics, and case studies.
After the initial presentation, two meetings were progressing in parallel, one oriented to technology and other business. There was a choice and I really would have liked to attend a further meeting. Specifically, I would have liked to be also in the 'What's new in IBM Cognos BI Authoring' and the SPSS Predictive Analytics..
For whatever reason we can find that in our Oracle database and tablespace have a lot to do a little cleaning to summarize those that are duplicates. Entoces OEM and we went to see a wonderful 50-liista tablespace with meaningless names, some empty, others tripled that have reached the maximum size considered (instead of three datafiles) etc etc ... Comes time to get down to work.
Remember that to view the contents of a tablespace we can go to Oracle Enterprise Manager and Management section> tablespaces mark you want, select Show Dependencies from the drop and then pressing Go Then we will see a second tab subsidiaries.It shows all dependent objects of the tablespace (content, come on).
Example a) Only rates
We find that we have three tablespaces IDX1, and IDX3 IDX2 containing indexes created by the same user APL and are of the same application, we want to do is summarize in a single tablespace IDX1. To do this we:
a) To export / import
b) Change rate index with the following sql:
ALTER INDEX [index] REBUILD TABLESPACE [new tablespace]
Option b) is a good way to do it because even if it takes more user certainly not even realize.