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

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

Question Posted / sunil.knl

1 Answers
18412 Views
HCL, IBM, I also Faced
E-Mail Answers

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 IN function works in informatica? Is it similar that of oracle IN function or different? Explain

2 Answers Mphasis,

What is a difference between complete, stop and abort?

0 Answers

What is the sql query overwrite in source qualifier in informatica

0 Answers Informatica,

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers Amdocs,

Write the prerequisite tasks to achieve the session partition?

0 Answers

Which development components of informatica have the highest usage?

0 Answers

can we override a native sql query within informatica? Where do we do it?

0 Answers

How the informatica server sorts the string values in Rank transformation?

1 Answers Informatica,

server hot-ws270 is connect to Repository B. What does it mean?

0 Answers Cognizant,

any body can say about all versions of informatica ?how many versions ?