what are the limitations of pushdown optimization
technique ?
Advance thanks
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / chandu
we can't implement for aggregator tranformation
we cant implement for master source in joiner transformation
| Is This Answer Correct ? | 7 Yes | 18 No |
What are the types of lookup transformation?
what are the Methods For Creating Reusable Transformations?
Explain the flow of data in Iinformatica?
In informatica workflow manager, how many repositories can be created?
what is surrogate id ?
How many input parameters can exist in an unconnected lookup?
Describe an informatica powercenter?
where to store informatica rejected data?
which is better perfomancewise lookup or joiner and why?can anyone give example?
what is sql override?what is the use of it?
what is left outer join?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy