🎴 Flashcard Mode
Oracle Warehouse Builder and Informatica PowerCenter Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
We can create/drop the indexes/tables at the________ level
AnswerClick to flip back
A
Source
B
Target
C
Session
💡 Explanation:
In Informatica PowerCenter, indexes and tables can be created or dropped at pre-session or post-session SQL commands at three levels: Source qualifier (before reading from source), Target (before writing to target), and Session (pre/post-session SQL). Workflow level doesn't have this SQL capability.