Interested to Buy Any Domain ? << Click Here >> for more details...
what are the limitations of pushdown optimization
technique ?
Advance thanks
- 3 Answers
- 41034 Views
- Puma, I also Faced
- E-Mail Answers
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 |
how to join two flat files in informatica?
my source is junk data how will u remove that junk data by using unix please any one replay me
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
How to extract original records at one target & Duplicate records at one target?
what is target load plan
What are the different types of code pages available in informatica & how to implement it in your project?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
in which situations do u go for sequence generator ?
How to send duplicates to one target and unique rows to one target?target is empty
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Teradata 
