what are the limitations of pushdown optimization
technique ?
Advance thanks
Answer Posted / rao
1)We can not apply push down optimization if mapping contain
aggregate transofrmation.
2)When we implement p.optimization ,the integration services
send logic to databases.because of this wa can not capture the
rejected records in reject file.
| Is This Answer Correct ? | 7 Yes | 14 No |
Post New Answer View All Answers
Explain the types of transformations?
Define Pmrep command?
What are Dimensional table?
What is resilience time?
tell me 5 session failure in real time how can you solve that in your project?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Explain how to import oracle sequence into informatica?
Explain the informatica workflow?
What is rank index in rank transformation?
Repository user profiles
wat are deployement groups in informatica, how it will be used for developers
Differentiate between a repository server and a powerhouse?
how tokens will generate?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?