why we r using presql&postsql in source qualifier?

Question Posted / sravanthi

1 Answers
6009 Views
HP, I also Faced
E-Mail Answers

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

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

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers Wipro,

Explain the informatica workflow?

0 Answers

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers TCS,

What is aggregate cache in aggregator transforamtion?

5 Answers

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers TCS,

How can you validate all mappings in the repository simultaneously?

0 Answers

What is operational data source (ODS)?

7 Answers

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers

When you move from devel to prod how will you retain a variable

1 Answers

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers

What if the source is a flat-file?

0 Answers

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers IBM,

For more Informatica Interview Questions Click Here