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 is the use of target designer?
Do you have to change the reject file b4 using reject loader utility.
what is data driven?
split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar
1 Answers Cap Gemini, TCS, Wipro,
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
How to eliminate duplicates from flat file..what is the procedure
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Explain about HLD and LLD ?
What is the difference between router and filter?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
what is confirmed dimension?
How to generate a single mapping for both the historical and incremental load.