what are the limitations of pushdown optimization
technique ?
Advance thanks
Answer Posted / 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 |
Post New Answer View All Answers
Different circumstance which drives informatica server to expel records?
Did u used latest transformations of 8.6.0? for what?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is blocking transformation?
What if the source is a flat-file?
What are the static cache and dynamic cache in informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is the need for an etl tool?
What is a node in Informatica?
How to create Target definition for flat files?
What is aggregator transformation in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is mapping debugger?