🎴 Flashcard Mode
Data Warehousing and Computer Hardware
Card1 / 20
Mastered0
Review0
QuestionClick to flip
If a session is configured for full pushdown optimization then
AnswerClick to flip back
A
The Integration Service pushes as much transformation logic as possible to both source and target database
B
If the Integration Service cannot push all the transformation logic to the database, it performs partial pushdown optimization
💡 Explanation:
Full pushdown optimization in Informatica pushes transformation logic to both source and target databases when possible. If not all logic can be pushed to the database, the Integration Service performs partial pushdown optimization rather than failing the session. Option A is incorrect because it only mentions source database.