Interested to Buy Any Domain ? << Click Here >> for more details...
why we r using presql&postsql in source qualifier?
- 1 Answers
- 6096 Views
- HP, I also Faced
- E-Mail Answers
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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Can we create multiple integration service on single repository?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is the Default Source Option For Update Strategy Transformation?
What are the measure objects?
What is resilience time?
What do mean by local and global repository?
how to load dimension table and fact table. plz tell me the steps.
Can anyone tell me the new features in Informatica 9 Version?
What are the designer tools for creating transformations?
What is a joiner transformation and why it is an active one?
tell me about your project functionality
How can repository reports be accessed without sql or other transformations?
How to load a Dimension ? and how to load a fact table?
COM components can be used in Informatica
