what are the limitations of pushdown optimization
technique ?
Advance thanks
Answer Posted / nitin
1) we can not perform PDO if we are using variable ports and informatica inbuilt functions.
2) If we have source and target on the different schema we can not go for full PDO, in this case either we have to go for source PDO or Target PDO.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can we override a native sql query within informatica?
Target increases every day even though no new record was inserted
What is domain in terms of informatica?
Briefly define reusable transformation?
What is fact table? Explain the different kinds of facts.
What is the maplet?
What is the difference between informatics 7x and 8x and what is latest version?
How do you load only null records into target?
Enlist few areas or real-time situations where informatica is required.
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
How to generate sequence numbers?
State the differences between sql override and lookup override?
Which is the t/r that builts only single cache memory?
Explain the different kinds of facts.