Interested to Buy Any Domain ? << Click Here >> for more details...
what are the limitations of pushdown optimization
technique ?
Advance thanks
- 3 Answers
- 41137 Views
- Puma, I also Faced
- E-Mail Answers
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
What is meant by incremental aggregation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How to load the data from people soft hrm to people soft erm using informatica?
How can we handle two sessions in informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How can one identify whether mapping is correct or not without connecting session?
Where is metadata stored?
Explain the pipeline partition with real time example?
What is the surrogate key?
How do you change a non-reusable transformation to reusable transformation?
How to do the error handling of if ur source is flatfiles?
What is fact table? Explain the different kinds of facts.
What could be the possible resons of locks by user?
can anyone explain me about retail domain project in informatica?
