locked
Time based vs event based RRS feed

  • Question

  • Hi Folks,

    What are the main differences between Time based and event based ETL?

    Which one is better?

    Wednesday, April 3, 2013 9:11 AM

Answers

  • As far as I know, if you want to do ETL at a fixed time and with a fixed periodicity then it is time based ETL.

    If you want an ETL to start when a certian event occurs (like a file arriving a shared location) then it is event based ETL.

    Which is better? Well it depends on you requirement and neither of the two has any advantage or disadvantage over other in terms of perofrmance.

    I think it is easy to set up the time based ETL compared to event based ETL because you have to write some logic to trigger the ETL once the event has occured.


    Nitesh Rai- Please mark the post as answered if it answers your question

    • Proposed as answer by Naveen Kumar K.R Wednesday, April 3, 2013 9:30 AM
    • Marked as answer by knra Wednesday, April 3, 2013 11:44 AM
    Wednesday, April 3, 2013 9:24 AM