Informatica - What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 254 of 327

What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?

Total Answers and Comments: 3

Last Update: October 24, 2009 Asked by: somusekharreddy

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

December 25, 2007 20:34:50

komalahanumantharao

Member Since: November 2007 Contribution: 12

RE: What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?

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

Is this answer useful? Yes | No

January 03, 2008 04:01:28

sekhar.ganta

Member Since: December 2007 Contribution: 5

RE: What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?

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.

Is this answer useful? Yes | No

October 23, 2009 05:26:29

suneetharoy

Member Since: June 2007 Contribution: 9

RE: What is the use of Pre SQL & Post SQL in source qualifier and target table? How to use?

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank