data warehouse n.
Skip this Video
Loading SlideShow in 5 Seconds..
Data Warehouse PowerPoint Presentation
Download Presentation
Data Warehouse

play fullscreen
1 / 6
Download Presentation

Data Warehouse - PowerPoint PPT Presentation

eshana
64 Views
Download Presentation

Data Warehouse

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Data Warehouse

  2. Loaded Data In DWH

  3. Ad Hoc Loading of Data to Data Warehouse • Access the data sources folder path: \\192.168.10.13\data_sources\FOXPRO • Access SSIS Package path: \\192.168.10.14\ssis package • Choose the folder of the Package to be run (ex: ADSM sources -> ADSM_PROJECT) • Run the following packages ADSM_EXTRACT -> ADMS_STAGING-> ADMS_TRANSFORM -> ADSM_LOAD

  4. Ad Hoc Loading of Data to Data Warehouse cont. • Access the error log text file for package errors Path: \\192.168.10.14\error_log Look for the text file with the same filename of the run package. (ex: package: adsm_extract error log: adsm_extract.txt) • Check data error by accessing path: \\192.168.10.14\dwreports\REPORTS_ERROR

  5. Scheduled SSIS Package • Access the data sources folder the day before the package is scheduled to run path: \\192.168.10.13\data_sources\FOXPRO • Wait for the email if the run is successful or not. • If successful, Check data error by accessing path: \\192.168.10.14\dwreports\REPORTS_ERROR

  6. Scheduled SSIS Package cont. • If the SSIS package failed check the path given in the email.