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 |
Explain the scenario which compels informatica server to reject files?
How do you take back up of repository?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
Differnce between filter and router?
What is polling in informatica ?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
What are the basic needs to join two sources in a source qualifier?
What is the difference between a connected look up and unconnected lookup?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.