locked
In real time how many packages are used to load data into database? RRS feed

  • Question

  • In real time how  many packages are used to load data into database?
    Thursday, September 8, 2011 12:00 PM

Answers

  • Generally in ETL 2 packages are used for loading one table in destination. One from source to staging and the other is from staging to the destination table. Some times we may use a single package also to acheive total ETL.

    As Chrita mentioned , Please provide more details for us to give a better answer.

    • Marked as answer by Eileen Zhao Thursday, September 15, 2011 5:00 PM
    Thursday, September 8, 2011 12:25 PM

All replies

  • It depends.

    How many data and tables do you want to load? You should provide more information that helps us to give you aa answer.+

    Thursday, September 8, 2011 12:06 PM
  • Normally what is the min size of data sent by client?
    Thursday, September 8, 2011 12:25 PM
  • Generally in ETL 2 packages are used for loading one table in destination. One from source to staging and the other is from staging to the destination table. Some times we may use a single package also to acheive total ETL.

    As Chrita mentioned , Please provide more details for us to give a better answer.

    • Marked as answer by Eileen Zhao Thursday, September 15, 2011 5:00 PM
    Thursday, September 8, 2011 12:25 PM
  • The generic answer would be atleast 1 package.


    Happy to help! Thanks. Regards and good Wishes, Deepak. http://deepaksqlmsbusinessintelligence.blogspot.com/
    Thursday, September 8, 2011 1:39 PM