Hi Thomas, Yes I have made the changes to the SILOS mapping also. But what I observed is that in the step Insert flow into I$ table, the column is part of the sub-query, but not getting selected in the outer query, Please advise what might be causing this. /* DETECTION_STRATEGY = NOT_EXISTS */ insert /*+ append */ into…

Hi Gianni Ceresa, Sure I will try TODATE function and will get back on how it goes.I just quoted Employee Headcount as an example, but we are looking really for YTD number of Hires against the Target Hires for the Year. Thanks, Dany