SQL query

 Source data extension: -



Target data extension created using the existing option to pick fields from source DE: -




Creating automation, SQL query: -


Selected target DE: -


Running query to pick records from source DE to target DE: -

Run query completed and records are showing in target DE: -










Comments

Post a Comment

Popular posts from this blog

Use Cases of Standard Data Extensions

Use Cases of Standard Data Extensions 1. Customer Data Storage Scenario : A retail business wants to store customer information, such as names, email addresses, and purchase history, for email marketing campaigns. Solution : Use a standard data extension to store and manage customer data securely and efficiently. Data Extension Structure Field Name Data Type Length Required Primary Key SubscriberKey Text 50 Yes Yes FirstName Text 50 Yes No LastName Text 50 Yes No EmailAddress EmailAddress N/A Yes No PurchaseHistory Decimal N/A No No Email - Marketing Cloud
Read more

Data retention policy

Image
📌 Task: Create & Monitor Data Extensions with Different Retention Policies 🚀 By ElearningIT Feb 18, 2025 Your objective is to: ✅ Create three separate Data Extensions (DEs). ✅ Apply a different retention policy on each DE. ✅ Monitor & analyze the impact over time. 🔹 Step 1: Create Three Data Extensions (DEs) 1️⃣ Navigate to: Email Studio > Subscribers > Data Extensions. 2️⃣ Click "Create" → Select Standard Data Extension. 3️⃣ Define the fields for all DEs using the structure below: Field Name Data Type Length Primary Key SubscriberKey Text 50 ✅ Yes Name Text 50 ❌ No Email EmailAddress 254 ❌ No Phone Phone 50 ❌ No SignupDate Date - ❌ No 4️⃣ Create three Data Extensions with unique names: DE_IndividualRetention (For Individual Record Retention) DE_AllRecordsRetention (For All Records Retention) DE_FullDeletion (For Data Extension & Records Retention) 5️⃣ Import at least 100 records in each DE (via CSV or manual entry). 🔹 Step 2: Apply Different Retention P...
Read more