Target has tapped PepsiCo executive Brian Cornell as its new chief executive, the Wall Street Journal reports.