pentaho kettle solutions

《pentaho kettle solutions》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、TableofContentsCoverTitlePageCopyrightDedicationAbouttheAuthorsCreditsAcknowledgmentsIntroductionTheOriginsofKettleAboutThisBookHowThisBookIsOrganizedPrerequisitesOntheWebsiteFurtherResourcesPartI:GettingStartedChapter1:ETLPrimerOLTPversusDataWarehousingWhatIsETL?ETL

2、,ELT,andEIIDataIntegrationChallengesETLToolRequirementsSummaryChapter2:KettleConceptsDesignPrinciplesTheBuildingBlocksofKettleDesignParametersandVariablesVisualProgrammingSummaryChapter3:InstallationandConfigurationKettleSoftwareOverviewInstallationConfigurationSumma

3、ryChapter4:AnExampleETLSolution—SakilaSakilaPrerequisitesandSomeBasicSpoonSkillsTheSampleETLSolutionSummaryPartII:ETLChapter5:ETLSubsystemsIntroductiontothe34SubsystemsSummaryChapter6:DataExtractionKettleDataExtractionOverviewWorkingwithERPandCRMSystemsDataProfilingC

4、DC:ChangeDataCaptureDeliveringDataSummaryChapter7:CleansingandConformingDataCleansingErrorHandlingAuditingDataandProcessQualityDeduplicatingDataScriptingSummaryChapter8:HandlingDimensionTablesManagingKeysLoadingDimensionTablesSlowlyChangingDimensionsMoreDimensionsSum

5、maryChapter9:LoadingFactTablesLoadinginBulkDimensionLookupsFactTableHandlingSummaryChapter10:WorkingwithOLAPDataOLAPBenefitsandChallengesWorkingwithMondrianWorkingwithXML/AServersWorkingwithPaloSummaryPartIII:ManagementandDeploymentChapter11:ETLDevelopmentLifecycleSo

6、lutionDesignAgileDevelopmentTestingandDebuggingDocumentingtheSolutionSummaryChapter12:SchedulingandMonitoringSchedulingMonitoringSummaryChapter13:VersioningandMigrationVersionControlSystemsKettleMetadataManagingRepositoriesVersionMigrationSystemSummaryChapter14:Linea

7、geandAuditingBatch-LevelLineageExtractionLineageLoggingandOperationalMetadataSummaryPartIV:PerformanceandScalabilityChapter15:PerformanceTuningTransformationPerformance:FindingtheWeakestLinkImprovingTransformationPerformanceImprovingJobPerformanceSummaryChapter16:Par

8、allelization,Clustering,andPartitioningMulti-ThreadingUsingCarteasaSlaveServerClusteringTransformationsPartitioningSummaryChapter17