Využití nástroje Informatica v datovém skladu a optimalizace ETL procesů

The graduation thesis is engaged in the problems of ETL development in terms of Business Intelligence solution. It analyses the wider portfolio of aplications supporting ETL development and offers the survey of its basic characteristics. There is a detail analysis of the pair of chosen instruments which utility is shown on the development of the real transformations. Then the advantages and possible risks of the transition on the higher edition of the product PowerCenter from Informatica company are being analysed too. The constituent of the thesis is engaged in optimalization procedure which is put into real operation of data warehouse and shows its benefit in term of computer time reduction The aim of the thesis is to show the detail look into the ETL instruments, formation of ETL transformations and not least the ways of optimalization of ETL transformations. The graduation thesis proposes to solve the problems in selection of convenient ETL instrument not only from the view of ETL developer in the shape of detailed comparison of the pair instrument usage but also from the view of management in the shape of general survey, basic characteristics and the comparison of wider porfolio of ETL instruments. In terms of detailed analysis the set Informatica PowerCenter should give us answers for the questions like: "What advantages does the upgrade of Informatica PowerCenter range 7 to range 8 bring?" or "What problems may that upgrade cause and how can we solve those problems? The part devoted to optimalization proposes to offer the outlook to the basic optimalization procedures inside the data warehouse and comparison of its contribution. In parallel with analytic part there is also proceeding the formation of practical part of the graduation thesis which consists in development of really used ETL transformations and in optimalization of selected ETL transformations of data warehouse. First the graduation thesis is concentrated on the analytic activity consisting in the products research which are on the top of ETL development. Then it is gathering the detailed knowledge of two instruments which is aplicated for the formation of ETL transformations The second analytic phase is concentrated on the optimalization procedures. The knowledge acquired in that phase is subsequently used in practice and the final analysis of those procedures and benefits is proceeding. The graduation thesis does not also miss out to partly outline the future development in the field of ETL.The main contribution consists in giving not only the comprehensive survey of ETL instruments but also in the detailed analysis of pros and cons of the pair of selected products. The thesis offered the answers to the questions asked in the outset connected with the transition to upper version of Power Center. The analysis of optimalization procedure enabled the optimalization of 29 ETL transformations and their high effectivity was proved too.