what is pre and post sql and what is diff between source
presql and target pre sql

Answer Posted / priyaraj

Pre SQL means that the integration service runs SQL
commands against the source database before it reads the
data from source.

Post SQL means IS runs SQL commands against target database
after it writes to the target.

Is This Answer Correct ?    26 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1866


Explian the Process of deployment groups in informatica

838


What is the status code in stored procedure transformation?

921


Could you explain what is enterprise data warehouse?

780


What is a repository? And how to add it in an informatica client?

919


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2367


What is source qualifier transformation in informatica?

767


What is meant by target load plan?

755


How do you remove duplicate records in informatica? And how many ways are there to do it?

924


What are mapplets? How is it different from a Reusable Transformation?

868


Differences between version 7.x and 8.x.

1662


Describe data concatenation?

813


What are the different types of repositories created using informatica?

906


what is the size of your data warehousing?

1877


What is a dimensional model?

760