Melibiose is widely used as a functional carbohydrate. Whole-cell biocatalytic production of melibiose from raffinose could reduce its cost. However, characteristics of strains for whole-cell biocatalysis and mechanism of such process are unclear. We compared three different Saccharomyces cerevisiae strains (liquor, wine, and baker's yeasts) in terms of concentration variations of substrate (raffinose), target product (melibiose), and by-products (fructose and galactose) in whole-cell biocatalysis process. Distinct difference was observed in whole-cell catalytic efficiency among three strains. Furthermore, activities of key enzymes (invertase, alpha-galactosidase, and fructose transporter) involved in process and expression levels of their coding genes (suc2, mel1, and fsy1) were investigated. Conservation of key genes in S. cerevisiae strains was also evaluated. Results show that whole-cell catalytic efficiency of S. cerevisiae in the raffinose substrate was closely related to activity of key enzymes and expression of their coding genes. Finally, we summarized characteristics of producing strain that offered advantages, as well as contributions of key genes to excellent strains. Furthermore, we presented a dynamic mechanism model to achieve some mechanism insight for this whole-cell biocatalytic process. This pioneering study should contribute to improvement of whole-cell biocatalytic production of melibiose from raffinose.