We have a custom object in Sales/Service cloud and I have synchronized those objects in Marketing cloud using Marketing cloud connect.
Now, We want to start a journey when we create a new record in our custom record.
We have created Data Extension with exact same fields as out synchronized custom object because we cant use Synchronized data extension directly into journey builder.
I want to SQL activity to load data from Synchronized data extension to data extension but I am not sure how and where to write this.
Please let me know.