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
Explain the features of connected and unconnected lookup.
Mention few advantages of router transformation over filter transformation.
Explain what are the different versions of informatica?
What is union transformation?
Describe an informatica powercenter?
What is resilience time?
How to configure mapping in informatica?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
How to elaborate tracing level?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the types of lookup transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to improve the performance of a session using sorter transformation?
How to implement security measures using repository manager?
Write the different tools in the workflow manager?