why we r using presql&postsql in source qualifier?



why we r using presql&postsql in source qualifier?..

Answer / amedela chandra sekhar

Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.

Is This Answer Correct ?    10 Yes 0 No

Post New Answer

More Informatica Interview Questions

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,


How can you complete unrcoverable sessions?

1 Answers  


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

0 Answers  


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,






What is the reusable transformation?

0 Answers  


Sequence generator, when you move from develoment to production how will you reset

0 Answers  


Explain the different kinds of facts.

0 Answers  


Could you explain what is enterprise data warehouse?

0 Answers  


I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,


What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,


Categories