Skip to content
Notice: Register here for a live training
techfura

All about Tech and Data Engineering

  • Home
  • About Us
  • Courses
  • Blog
  • Contact
  • Services

Category: SSIS

SSIS 2016: An efficient way to handle transform and load of SCD2

May 13, 2020May 13, 2020 Kenneth_pro_

Quick Review:This blog post is about type two slowly changing dimensions (SCD2).  This is when an attribute change in row 1 results in SSIS expiring the current row and inserting a new dimension table row like this –>  SSIS comes Read More …

ETL/ELT, SSISLeave a comment

Categories

  • Azure (20)
    • ADF (3)
    • ADLA (13)
      • USQL (13)
    • Azure Services (1)
    • Azure SQL (2)
    • Data and Analytics (1)
  • Azure Databricks (1)
  • ETL/ELT (1)
    • SSIS (1)
  • Excel (1)
    • Functions (1)
  • Programming (28)
    • C# (5)
    • HTML/CSS (3)
    • JavaScript (6)
    • TSQL (13)
      • Built-in Functions (3)
      • Data Conversion (1)
      • Errors (2)
      • Indexes (1)
      • Mostly Asked Questions (3)
      • Stored Procedure and UDF (3)
  • Reporting (2)
    • SSRS (2)
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« Dec    

Recent Posts

  • A Stored Procedure to generate a random token
  • U-SQL (Intro)
  • How to Coalesce Excel Data
  • Report Server URL error: Unable to validate the integrity of encrypted data
  • Configuration of the Report Server URL in SSRS 2019

Traffic Counts

PHP Hits Count
© 2021 Techfura All rights reserved.