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



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

Answer / 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

More Informatica Interview Questions

How to jion 2 tables, without using any condition?

11 Answers   Amazon,


How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  


if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  


Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,






can any one explain me about junk dimension

4 Answers  


Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,


In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,


what is the size of your data warehousing?

0 Answers   IBM,


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


Where are the source flat files kept before running the session?

0 Answers   Informatica,


What is the difference between OLTP and ODS?

4 Answers  


Categories