Maybe ypu can rty using an excel file and concatenate to your fact table and check them with a field FLGMemoItem =1, something like this:
Select * ordertable;
ProductID, //Created on the fly or if you have itin excel file just load it.
1 as FLGMemoItems
My issue is i need to load into items dimension table based on the sales detail table for which no item exists in the item dimension. Memo items in sales detail table do not exist in item dimension and hence the join created by QV between sales detail and item dimension based on item field will not return all records in sales detail.
Should i be using resident load for this. If so how would i add into item dimension table all the memo items in sales detail table???