How we will implement Pushdown Optimization and Types in Informatica with better examples
- 4 Answers
- 12887 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sridhar,informatica developer
normally pushdown optimization is used for eliminating
bottlenecks from session and to increase the performance of
your session.
here t he integration service pushing the business logic to
the target or source or both.
pushdown optimization can do in 3 ways
1)source side
2)target side
3)full
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
According to his methodology what all you need before you build a datawarehouse
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How do we call shell scripts from informatica?
Can you generate sequence numbers without using the sequence generator transformation?
Different circumstance which drives informatica server to expel records?
What do mean by local and global repository?
what is size of u r database?
What is a transaction control transformation?
Explain sessions. Explain how batches are used to combine executions?
What are the different transaction levels available in transaction control transformation?
have u done any performance tuning? how u ll do?
Mention a few design and development best practices for informatica?
What is meant by pre and post session shell command?
Write the unconnected lookup syntax and how to return more than one column.
