SSIS Error (Union All + Data Conversion)I received the following error message using Union All tool in SSIS after converting data type using data conversion.Jun 2, 2021Jun 2, 2021
Using XLOOKUP to retrieve dataXLOOKUP is a modern replacement for the VLOOKUP function. It is a flexible and versatile function that can be used in a wide variety of…Apr 15, 2021Apr 15, 2021
Using List.Sum function for adding columnsI worked on data cleansing and standardization last week and found out that List.Sum function was extremely useful for grouping the…Mar 9, 2021Mar 9, 2021
Generating Surrogate Key with SSIS using script componentSurrogate keys are integers used to connect the fact to the dimension tables of a data warehouse.Feb 19, 2021Feb 19, 2021
Select all the even number records from a table & all the odd number recordsSCENARIO:Feb 10, 2021Feb 10, 2021
Convert Data From Wide To Long Format in ExcelSo, if you have data that is stored in a wide format in excel. But, you want to reshape it to a long format. Then, here is the solution…Feb 5, 20213Feb 5, 20213