TRAINING CONTENTDATA WAREHOUSE FUNDAMENTALSAn Introduction of Data warehousingPurpose of Data warehouseData ware ArchitectureSourceIntegration LayerStaging AreaTargetODSOLTP Vs Data warehouse ApplicationsData MartsData Warehouses Building ApproachDATA MODELINGNormalizationTypes of NormalizationIntroduction of Data ModelingEntity Relationship ModelingDimensional ModelingStart SchemaSnow Flake SchemaDimensions tables Fact TablesFact less Fact TablesDifferent types of factsConformed DimensionRole playing dimensionJunk DimensionsMonster DimensionsDegenerated DimensionsAggregate TableSurrogate KeysChange data captureSlowly changing Dimensions?Different types of SCD’sPROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)Introduction of Extraction,Transformation and cleansing LoadingBusiness IntelligenceOLAP CubesOLAP Cube OperationsData MiningTypes of ETL and Reporting tools