prav2000

 Profile Answers by prav2000 

• Dec 21st, 2006

 

Push and Pull strategies determine how data comes from source system to ETL server.

Push : In this case the Source system pushes data i.e.(sends data) to the ETL server.

Pull : In this case the ETL server pulls data i.e.(gets data) from the source system.

noverino

 Profile Answers by noverino Questions by noverino

• Feb 22nd, 2007

 

Push strategies:
  - ETL waiting notification for data would be processed. If the notification contain
    no data to be processed, ETL must retrieve itself to the source.
  - Used in realtime ETL

Pull strategies:
  - ETL schedule job to retrieve data
  - Used in scheduled ETL