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 do you mean by enterprise data warehousing?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is difference between a gateway node and worker node?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the informatica performance improvement tips
Do you find any difficulty while working with flat files as source and target?
How to do the error handling of if ur source is flatfiles?
What is the meaning of decode in informatica?
Explain the types of lookup transformation?
Differentiate between sessions and batches?
What is a snowflake schema?
Design a mapping to load a target table with the following values from the above source?
How to use procedural logic inside infromatica?
How do you migrate data from one environment to another?