What is the difference between source preload and source postload?

Questions by prasad mallipeddi

Showing Answers 1 - 3 of 3 Answers

koti

  • Oct 31st, 2011
 

It is a process of performing something before pulling the data from source and after loading the data into target... It is known as pre sql and post sql...

  Was this answer useful?  Yes

Anubhav Raikar

  • Nov 15th, 2011
 

If you are asking this in terms of Stored Procedure Transformation, then the SP would be run before the Source fetches any data (in case you select Source PreLoad) .. and in case of Source PostLoad the SP would run after the data is being fetched by the source. You also have Target Preload and PostLoad.

  Was this answer useful?  Yes

Sumithav29

  • Dec 20th, 2011
 

In Stored Procedure transformation we can also specify when the SP should run.Its Normal,Pre-load of the Source,Post-load of the Source,Pre-load of the Target and Post-load of the Target.

Pre-load of the Source: Before the session retrieves data from the source, the stored procedure runs. This is useful for verifying the existence of tables or performing joins of data in a temporary table.
Post-load of the Source: After the session retrieves data from the source, the stored procedure runs. This is useful for removing temporary tables.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions