Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2017
    Posts
    2

    Unanswered: DataWarehousing-ETL

    I want to get Supplier Wise payment collection on a yearly basis. I am currently using relational database system. Shall I maintain a separate warehouse for it. Also how can we automate the jobs in datawarehouse such that as soon as the data is entered in SQL server, the warehouse is updated accordingly.

  2. #2
    Join Date
    Oct 2014
    Posts
    291
    Provided Answers: 7
    MS SSIS and SQL Agent Jobs.
    70-461 SQL Certified.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •