why we r using presql&postsql in source qualifier?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

In development project what is the process to follow for an etl developer from day1

1497


How big was your fact table

1517


Which transformation should we use to normalise the COBOL and relational sources?

980


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2108


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

865


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

2170


How do you use reject loader.

2344


What are the guidelines to be followed while using union transformation?

892


How can we remove the duplicates from flat file source?

804


Explain what transformation and how many are there in informatica?

728


What is aggregate cache in aggregator transformation?

858


How you can differentiate between connected lookup and unconnected lookup?

842


What is the meaning of up gradation of repository?

1627


What is the need for an etl tool?

856


Can u generate reports in Informatica?

859