Why Lookup File set must need a Key column?
-
Remove Duplicates
-
Memory Limit
-
Reference to a Lookup
-
None of above
A
Correct answer
Explanation
Lookup File Sets require a key column to identify duplicates. When reading from a Lookup File Set, duplicate records based on the key are automatically removed, ensuring only unique records are returned. This is a key design purpose - not for memory limits or general references. The key column enables duplicate detection and removal.