It is likely that you will not taste sour cream in your cake. The flavor is very subtle. The flavor may come off as a slightly tangy flavor, which would be similarly apparent if using greek yogurt as well.