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

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1404


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1916


can any one give some examples for pre sql and post sql(Except dropping and creating index).

3761


What are roles and groups and benefits of using them?

775


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1733


What is powercenter on grid?

939


What is main use of mapplet?

874


What is blocking transformation?

913


While importing the relational source definition from the database, what are the metadata of source that will be imported?

1040


What are the main features of Oracle 8i with context to datawarehouse?

1874


How is union transformation utilized?

780


As union transformation gives UNION ALL output, how you will get the UNION output?

868


What is informatica metadata and where is it stored?

770


What is rank transform?

757


What is a snowflake schema?

759