Pubudu Dewagama

SQL MERGE Query to Insert, Update and delete records in the destination table

In the Data warhousing application, we have to update Data warehouse according to the source data. In the SQL Server wecan use the Merge qu...

SQL MERGE Query to Insert, Update and delete records in the destination table

Reviewed by Pubudu Dewagama on 10:37:00 PM Rating: 5

In this post, I am going to remove the duplicates rows of the below table. Step1 :- Drag and drop the Data Flow task to Control Flow. S...

SSIS 2017 :- How to remove duplicate records using SSIS package

Reviewed by Pubudu Dewagama on 9:25:00 PM Rating: 5

The following memory and processor requirements apply to all editions of SQL Server: Memory Minimum: Express Editions: 512 MB / All oth...

How to install SQL Server 2017 on windows 10 Environment

Reviewed by Pubudu Dewagama on 9:02:00 PM Rating: 5

In this post I am going to explain how to add a filter to ODI mapping. For this tutorial, I am using previously posted article ( http://...

ODI 12c :- Oracle Data Integrator 12c Filter example.

Reviewed by Pubudu Dewagama on 9:41:00 PM Rating: 5