$("#my_table_id table th a").attr("title","This is table header");
Above will add same tooltip to all the columns but you can make jquery to make specific selection.
Hope this helps!!!
@nilaksh92 @cblanton is the tooltip text static tooltip or would it be based on the table header. Please add some example of what the table header might be and accordingly what kind of Tooltip text need to be displayed.