komalahanumantharao

 Profile Answers by komalahanumantharao Questions by komalahanumantharao

• Dec 25th, 2007

 

Pre SQL is thesql statement to beexecuted before perfoming the mappingson the target table and post is to be executed after performingthe tasks
  ex;
post sql is the that if any errors occure we can send an email or write logs to know the error

sekhar.ganta

 Profile Answers by sekhar.ganta Questions by sekhar.ganta

• Jan 3rd, 2008

 

I think above answer may be not correct

In source qualifier t/r : If you write any pre sql  that statement will execute is source database connection before reading the data. If you write that query in post sql that query will execute after readiong the data.

In target table: Now the query will execute in target database connection before and after loading the data.

suneetharoy

 Profile Answers by suneetharoy Questions by suneetharoy

• Oct 23rd, 2009

 

Pre SQL: The SQL query fires initially when loading to that database.

Example for Pre SQL: Suppose my requirement is to load the records daily. If some updates I have to reload the records for that particular day. In that case I will write a pre-SQL so that when ever I run first it will delete the records from the database and reload the latest records.

Post SQL: The
SQL query fires at the end i.e., after loading the records to the database.

Example for Post SQL: In a case that I have to delete the records for a particular day, once the entire ODS load finishes the stage records has to be deleted. In such cases I will write a post
SQL to delete the stage records once it loads to ODS.