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
Which development components of informatica have the highest usage?
Explain the different lookup methods used in informatica?
What is lookup change?
Where is metadata stored?
What is workflow? What are the components of the workflow manager?
What is the surrogate key?
What is pmcmd command?
Explain what is informatica metadata and where is it stored?
How to elaborate tracing level?
Please let me know how to make Data masking in informatica..
Why is sorter an active transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How do you load only null records into target? Explain through mapping flow.
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?