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

Explain in detail about scd type 1 through mapping.

0 Answers  


I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  


how to remove staging area

1 Answers  


Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 Answers  


Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,


How to display First letter of Names in Caps?

7 Answers  


What are multi-group transformations?

0 Answers   Informatica,


r u done any partitions in ur project?

0 Answers   TCS,


in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,


Which is the t/r that builts only single cache memory?

0 Answers  


What is a connected transformation?

0 Answers   Informatica,


tell me the datawarehouse defination,and it is maintaing hystorical data meaning,what is the use

1 Answers  


Categories