U.S. sovereign rating downgrades in the past have had very short-lived impact on the dollar, according to Société Générale.