You can connect one Business Unit (BU) in an MC Org to one and only one SF CRM instance. However an MC Org can have multiple BUs - and if Multi-org is enabled in MC, then you can technically connect each BU to a different SF CRM instance. You can even have multiple BUs connecting to the same SF CRM instance.

help.salesforce.com/s/articleView?id=sf.mc_es_personalization_strings.htm&type=5

Not that I know of - the Data Extract activity pulls the full DE. But you could use a SQL Query activity prior to the Data Extract to pull in only the fields you need temporarily to a new DE and then do the data extract from this new DE. You can later delete the temporary one that you created.

Nice - thank you Daryl 👍

You can use the DataExtension related REST APIs for this - there's both asynchronous and synchronous APIs - developer.salesforce.com/docs/marketing/marketing-cloud/guide/asynchronous_processing_scenarios.html. The examples in the documentation should be simple enough to follow.

The folder is configured in File locations under setup. So if u are looking to use a specific folder / subfolder, ensure u have a File Location created for each folder u wish to reference. Then in the automation, when you select the File Location, the folder path will automatically be selected based on the configuration from setup > file locations.

This substitution string only works if you are using a filedrop entry source for your automation. Please check the same

@@sfmctrailblazers Yes i'm doing it for file drop entry source but what I caught is if i'm selecting the location Import then only it works . if i have any folder in import and adding the file into that folder it is not catch that file.

and in File drop when you select No Naming you have to select the folder under the import.

@@PriyanshuJain-tn7tm when you use the subfolder, did you set up a separate File Location in setup to denote that subfolder? Mktg Cld does not recursively go into subfolders and check for files dropped - it only looks at the root of the folder you specify in Location. If you have a subfolder under Import called ABC, then you need to create a new File Location for ABC using the Relative path option and specify Import\ABC - and then use this as the location.

It is not always necessary that you must have a primary key - you need to evaluate how you would be using the data. If you expect that the customer record should be unique in a DE, then yes you need a unique identifier like customer id as PK. But lets say you are using a DE for Journey entry where the customer may reenter multiple times - setting a primary key in such cases will cause the reentries to fail. A PK is not mandatory for a DE but need to be used appropriately based on the scenarios where the data will be used

@@sfmctrailblazers Awesome, thanks for the explanation.