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
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 ?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are roles and groups and benefits of using them?
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
What is powercenter on grid?
What is main use of mapplet?
What is blocking transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the main features of Oracle 8i with context to datawarehouse?
How is union transformation utilized?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is informatica metadata and where is it stored?
What is rank transform?
What is a snowflake schema?