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

What is the use of transformation?

576


How to do unit testing in informatica? How to load data in informatica ?

653


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1320


How to generate sequence numbers using expression transformation?

646


What is update strategy transform?

578






What is mapplet in informatica?

598


How do you handle two sessions in Informatica

669


Could you explain what is enterprise data warehouse?

556


Explian the Process of deployment groups in informatica

659


Suppose we do not group by on any ports of the aggregator what will be the output?

580


What differs when we choose the sorted input for aggregator transformation?

574


Why sorter is an active transformation?

754


What is the benefit of session partitioning?

598


Explain what is informatica metadata and where is it stored?

612


What is a pre-defined event and user-defined event?

579