what is pre and post sql and what is diff between source
presql and target pre sql
Answer Posted / priyaraj
Pre SQL means that the integration service runs SQL
commands against the source database before it reads the
data from source.
Post SQL means IS runs SQL commands against target database
after it writes to the target.
| Is This Answer Correct ? | 26 Yes | 3 No |
Post New Answer View All Answers
what is size of u r database?
How can a transformation be made reusable?
What is data transformation manager process?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Whats there in global repository
How to use pmcmd utility command?
Can we create two repositories on same database instance in oracle?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Define update strategy?
tell me about your project functionality
How you can differentiate between connected lookup and unconnected lookup?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain about Informatica server process that how it works relates to mapping variables?
What are ETL Tools?