I know the Inferred Dimension Members is about handling placeholder records that were added during fact table load. But since the dimension has not been loaded, then how can we load fact table firstly? Could you give me an example what's the usage of this funtion? Thanks

This link should help. It is in simple terms. http://mohitnayyar.blogspot.com/2008/05/ssis-approach-to-handle-inferred.html vinu

This link should help. It is in simple terms. http://mohitnayyar.blogspot.com/2008/05/ssis-approach-to-handle-inferred.html Also you can refer this link: http://www.mssqltips.com/tip.asp?tip=1446 vinu

Thank you Vinu. Now I have two options: 1) add the new business key to the dim, add another lookUp to reload the surrogate key and then use an 'union all' 2) add the new business key to the dim, add another lookUp to reload surrogate key and then instert the data to the fact table. So in my data flow i have two destinations, one for Inferred data, another for regular data from the first lookup. I think the second option could be better, because we don't need the 'union all', however, I'm not sure whether those two destinations will block the fact table (I will use bulk load). So, which one could be better or there is another better one? Thx for your help!

"add the new business key to the dim, add another lookUp to reload surrogate key and then instert the data to the fact table." Looks good.vinu

hello all , Regarding this topic i have found the blog describing about the "Creating Inferred Dimension Members with SSIS" in this link http://www.sqlservercentral.com/articles/Data+Warehouse/71233/ Hope it will help us too understand more about the Inferred Dimension . Thanks Anil Maharjan anil