🎴 Flashcard Mode
ETL Tools - DataStage and Ab Initio
Card1 / 19
Mastered0
Review0
QuestionClick to flip
True/False: Data needs to be partitioned on same key before using the lookup local functions.
AnswerClick to flip back
A
True
💡 Explanation:
Lookup local functions work on partitioned data where the partition key matches the lookup condition. If data isn't partitioned on the lookup key, each partition would need to search the entire lookup cache, defeating the purpose of local lookup optimization.