I have a column of data with values separated by commas. I have few tricks up my sleeve but they require a too many temp resident loads. I was hoping to find the most optimized solution for this type of conversion:
Thank you so much for your help. It may be the way I was loading my fact table. But moving it to the initial load and creating the Guest column from the original QVD instead of the resident table, made it work. I am all set now. I am sure it must have been the fact table. I am cleaning that up now.