Having multiple active credit cards might not work for everyone, but here's what we've learned over the years.