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

Loading in 2 Seconds...

play fullscreen
1 / 6

Data Warehouse - PowerPoint PPT Presentation


  • 64 Views
  • Uploaded on

Data Warehouse. Loaded Data In DWH . 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)

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Data Warehouse' - eshana


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
ad hoc loading of data to data warehouse
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

ad hoc loading of data to data warehouse cont
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

scheduled ssis package
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

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