2o18 PGA CREW
__________.
______\\ |
.\ |
|| pROPAGANDA! |
|| ----------- |
._______ .______. ____ ____| ____ ____
| _ /__|_ _ |_______\__ ).________\__ )____. .__\ \ ._\__ )_.
| __/ ___/ / | _ / _ | _ | _ | |___| \ \| _ |
| | | |______| __/ \ | \ | \ | _ | |\ \ \ |mK^dS!
_|___| |________| |_|______|____ |______| | | |/ /_______|___
\ |___| |___| | |___| |___/___/ /
\____________________________________|______________|__________________/
| || | |
| || 2o18.o2.o1 | |
| - HOT.OFF.THE.PRESS !! || | WE.WARP.YOUR.MIND.WITH |
| -------------------- `----------------' ---------------------- |
| ....[PROPAGANDA].................................................. |
| || : |
| || PACKT.PUBLISHING.BUILDING.A.DATA.MART.WITH.PENTAHO.DATA. : |
| || INTEGRATION.TUTORiAL-PROPAGANDA : |
| ||...............................................................: |
| |
| ....[URL]......................................................... |
| || http://tinyurl.com/y9ehdgga : |
| ||...............................................................: |
| |
| ....[ISBN/COURSE.NUMBER].......................................... |
| || ISBN-13: 9781782168638 : |
| ||...............................................................: |
| |
| ....[COURSE.iNFO]................................................. |
| || By: Diethard Steiner : |
| || Publisher: Packt Publishing : |
| || Price: 30,23 euro : |
| || Copyright: 2014 : |
| || Release Date: December 31, 2013 : |
| || ISBN-13: 9781782168638 : |
| || Running Time: 00:01:50 : |
| || Topics: ETL / Pentaho / Data Warehousing : |
| || ------------------------------------------------------------- : |
| || Description : |
| || ----------- : |
| || Companies store a lot of data, but in most cases, it is not : |
| || available in a format that makes it easily accessible for : |
| || analysis and reporting tools. Ralph Kimball realized this a : |
| || long time ago, so he paved the way for the star schema. : |
| || : |
| || Building a Data Mart with Pentaho Data Integration walks you : |
| || through the creation of an ETL process to create a data mart : |
| || based on a fictional company. This course will show you how to: |
| || source the raw data and prepare it for the star schema step-by: |
| || -step. The practical approach of this course will get you up : |
| || and running quickly, and will explain the key concepts in an : |
| || easy to understand manner. : |
| || : |
| || Building a Data Mart with Pentaho Data Integration teaches you: |
| || how to source raw data with Pentaho Kettle and transform it so: |
| || that the output can be a Kimball-style star schema. After : |
| || sourcing the raw data with our ETL process, you will quality : |
| || check the data using an agile approach. Next, you will learn : |
| || how to load slowly changing dimensions and the fact table. The: |
| || star schema will reside in the column-oriented database, so : |
| || you will learn about bulk-loading the data whenever possible. : |
| || You will also learn how to create an OLAP schema and analyze : |
| || the output of your ETL process easily. : |
| || : |
| || By covering all the essential topics in a hands-down approach,: |
| || you will be in the position of creating your own ETL processes: |
| || within a short span of time. : |
| || : |
| ||...............................................................: |
| |
| ....[TABLE.OF.CONTENTS]........................................... |
| || : |
| || GETTING STARTED : |
| || - The Second-hand Lens Store : |
| || - The Derived Star Schema : |
| || - Setting up Our Development Environment : |
| || AGILE BI – CREATING ETLS TO PREPARE JOINED DATA SET : |
| || - Importing Raw Data : |
| || - Exporting Data Using the Standard Table Output : |
| || - Exporting Data Using the Dedicated Bulk Loading : |
| || AGILE BI – BUILDING OLAP SCHEMA, ANALYZING DATA, AND : |
| || IMPLEMENTING REQUIRED ETL IMPROVEMENTS : |
| || - Creating a Pentaho Analysis Model : |
| || - Analyzing Data Using Pentaho Analyzer : |
| || - Improving Your ETL for Better Data Quality : |
| || SLOWLY CHANGING DIMENSIONS : |
| || - Creating a Slowly Changing Dimension of Type 1 Using Insert/: |
| || Update : |
| || - Creating a Slowly Changing Dimension of Type 1 Using : |
| || Dimension Lookup Update : |
| || - Creating a Slowly Changing Dimension Type 2 : |
| || POPULATING DATA DIMENSION : |
| || - Defining Start and End Date Parameters : |
| || - Auto-generating Daily Rows for a Given Period : |
| || - Auto-generating Year, Month, and Day : |
| || CREATING THE FACT TRANSFORMATION : |
| || - Sourcing Raw Data for Fact Table : |
| || - Lookup Slowly Changing Dimension of the Type 1 Key : |
| || - Lookup Slowly Changing Dimension of the Type 2 key : |
| || ORCHESTRATION : |
| || - Loading Dimensions in Parallel : |
| || - Creating Master Jobs : |
| || ID-BASED CHANGE DATA CAPTURE : |
| || _ Implementing Change Data Capture (CDC) : |
| || - Creating a CDC Job Flow : |
| || FINAL TOUCHES: LOGGING AND SCHEDULING : |
| || - Setting up a Dedicated DB Schema : |
| || - Setting up Built-in Logging : |
| || - Scheduling on the Command Line : |
| || : |
| ||...............................................................: |
| |
| ....[SiZE.NUMBER.OF.DiSCS]........................................ |
| || 28 Files @ 15,000,000 Bytes = 394 MB : |
| ||...............................................................: |
| |
| ....[GREETINGS/Hi-5's]............................................ |
| || kEiSO - QUASAR - PRODEV - ELOHIM - JGTiSO - OXBRiDGE : |
| ||...............................................................: |
| |
| ....[FUCK-YOU's/NEWS]............................................. |
| || PROPAGANDA would like to see the quality and documentation of : |
| || the bookware scene to increase. Quality not Quanity. Original : |
| || untouched, content! We also would like to see the following to: |
| || allow automation of cataloging of bookware releases. : |
| || : |
| || RLS DIR / TITLE MUST BE FROM ISBN10/13 RELEASE INFO. : |
| || : |
| || ISBN13 NUMBER as FILE NAME OR IN RLS NAME APPROPRIATELY LABLED: |
| || IN NFO AT THE LEAST. : |
| || : |
| || PROPER AGREEMENT OF TO USE .ISO OR NOT ? THESE ARE NOT DVD'S : |
| || LIKE IN THE PAST WHEN BOOKWARE WAS ORDERED BY DISK. THESE ARE : |
| || USUALLY WEB RELEASES NOW DAYS AND THE ISO PROVIDES NO QUALITY.: |
| || : |
| || Working/Sample Files *MUST* be included and labled in archive : |
| || ISBN13#-WorkingFiles.zip or ISBN#-SampleFiles.zip : |
| || : |
| || PROPAGANDA WOULD LIKE TO SEE THE LIKES OF JGT/QUASAR/kE & : |
| || OTHERS WORK FULFILLED AND THE QUALITY OF BOOKWARE PRESERVED & : |
| || PROVIDE A MECHANISM TO EASILY CHECK FOR DUPE AND COMPLETE RELS: |
| || : |
| || Many places refuse to accept bookware because of the size and : |
| || lack of quality control mechanisms to provide certain quick : |
| || actions to releases that do not adhere to quality / dupes... : |
| || --------------------------------------------------------------: |
| || Lastly - PROPAGANDA, would like to thank the people in the : |
| || bookware industry for doing what they do. We believe that : |
| || the real money to support the industry should come from the : |
| || corporate licensing contracts - that people who want to learn : |
| || should be able to do so. We encourage bookware / video / : |
| || e-learning and major Software and Hardware vendors to allow : |
| || access to these materials to whomever may want to learn these : |
| || technologies, so that we can bridge the educational gaps in : |
| || our communities world-wide. Companies like Cisco / Oracle / : |
| || IBM & Micro$oft already make billions off of their support : |
| || contracts and hw/sfw sales - Do they seriously benefit from : |
| || preventing people from learning these technologies? : |
| || : |
| || Regardless of the above, there are people who are instructors : |
| || and such who spend time writing and developing these courses, : |
| || we salute these ladies and lads, and hope they will encourage : |
| || a different way of funding these projects. They *DO* deserve : |
| || our support! If you have the means or you work in IT and you : |
| || use one of these courses to better yourself and get a raise, : |
| || then *BUY* one of these courses and show support to the hard : |
| || working instructors, editors, film crews and so-on that made : |
| || this course possible. IF YOU LIKE IT, *BUY* IT OR GET YOUR : |
| || WORKPLACE TO BUY A CORPORATE SUPPORT CONTRACT!! WE DID! : |
| || ------------------------------------------------------------- : |
| || /dev/random: : |
| || ------------ : |
| || They paint the world full of shadows, and then tell their : |
| || children to stay close to the light, their light, their : |
| || reasons, *their* judgements. Because in the darkness there be : |
| || dragons, but it is not true. We can prove that it is not true.: |
| || In the dark there is discovery, there is possibility, there is: |
| || freedom in the dark when someone has illuminated it. And who : |
| || who has been so close as we are right now? : |
| || : |
| || PGA is dedicated to the purity of real piracy, not for making : |
| || money off of it, or exploiting the scene in *ANY* way. We are : |
| || the true pirates, illuminating the darkness, giving birth to : |
| || possibilities in a time where so little seems achievable. Join: |
| || us and usher in this new age. : |
| || ------------------------------------------------------------- : |
| || PGA IS LOOKING FOR: : |
| || ------------------ : |
| || Absolutely nothing... We have our methods and do not want acc : |
| || to your accounts, we do not want to affil your site, we do not: |
| || give files out and we are grown, have ladies / boyfriends / : |
| || lovers. If you are clever enough to find us and have a keen : |
| || point of view, who knows! : |
| ||...............................................................: |
|....................................................................|
- LAYOUT & DESiGN BY #MONk!# oF DiViNE STYLERS! -