© 2026 Hashnode
Microsoft's Data Factory in Microsoft Fabric represents the evolution of Azure Data Factory (ADF), offering enhanced cloud-scale data movement and transformation services. This advancement aims to provide a more integrated, user-friendly, and enterpr...

Secure File Transfer Protocol (SFTP) relies heavily on SSH key pairs for robust authentication and secure data transmission. This post provides a comprehensive guide to generating and managing these crucial keys. Key Pair Creation: A Step-by-Step Wal...

Introduction to Slowly Changing Dimensions (SCD) Type 2 Slowly Changing Dimensions (SCD) Type 2 is a data warehousing technique used to track historical changes in dimension data over time. Unlike SCD Type 1, which overwrites old data, Type 2 preserv...

Step 1: Inspecting the CSV Files in Data Lake: Your First Step to Data Optimization Step 2: Configuring the Data Flow Sources: Pointing to the Customer.CSV Files and use Join tool after that. Step 3: Use Join on Customer id as that is the common fi...

Step 1: Inspecting the CSV File in Data Lake: Your First Step to Data Optimization Step 2: Configuring the Data Flow Source: Pointing to the Customer.CSV File Step 3: Filtering Even Customer IDs: Streamlining Data with ADF's Filter Data Flow Step ...

When designing pipelines in Microsoft Fabric or Azure Data Factory (ADF), understanding the execution flow of activities is critical. One setting that often causes confusion is "Wait on Completion"—especially in how it differs from parallel execution...

Step 1: Check the existing data in the employee table: Step 2: Change the data manually in the csv file in data lake: we need to check whether this change will be visible in the table or not (definitely at the end). Step 3: Settings in “Sink” opti...
