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
How can we use mapping variables in informatica? Where do we use them?
Can you use flat files in Mapplets.
How can you generate reports in informatica?
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?
Which are the different editions of informatica powercenter that are available?
How to convert multiple rows to single row (multiple columns) in informatica
Explain what transformation and how many are there in informatica?
What is the difference between a repository server and a powerhouse?
Why do we need informatica?
Describe an informatica powercenter?
Tell me about Propagate functions in informatica
What is the difference between router and filter?
how to create user defined function (udf) in informatica
Is it possible to define a single node as a Gateway node as well as worker node?
What is data transformation manager process?