'Whet' means to sharpen (whetstones are used to sharpen knives, for example), so whetting one's appetite means to sharpen appetite, or to make one hungrier (for knowledge, food, whatever).