I am looking for advice on connecting Marketo data into a data warehouse (Redshift). My big concern is trying to prevent a circular data motion of separately connecting Marketo's Leads Table to SFDC's Leads and Contacts. I'm currently seeing a lot of duplicate in reporting from this. I'd like to have this date be represented as one person but haven't been able to pair this connection appropriately.
Does anyone have any advice in pairing MKTO Leads table to SFDC objects through a data warehouse.