Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
What cable would I need to buy to Hookup 2010 Air to a (late) 2006 IMac?

What do you mean by "hookup"? What are you wanting to do achieve? A well thought out and worded question usually yields better answers.

You could use the Apple USB Ethernet adapter and then use a crossover ethernet cable to directly connect them or two straight through ethernet cables and a switch.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.