Chloe WongSSIS Error (Union All + Data Conversion)I received the following error message using Union All tool in SSIS after converting data type using data conversion.1 min read·Jun 2, 2021----
Chloe WongUsing 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…2 min read·Apr 15, 2021----
Chloe WongUsing 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…1 min read·Mar 9, 2021----
Chloe WongGenerating Surrogate Key with SSIS using script componentSurrogate keys are integers used to connect the fact to the dimension tables of a data warehouse.3 min read·Feb 19, 2021----
Chloe WongSelect all the even number records from a table & all the odd number recordsSCENARIO:2 min read·Feb 10, 2021----
Chloe WongConvert 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…2 min read·Feb 5, 2021--2--2