Below is the join i perform that i do with NBI_DIM_OBS table :
left outer join prj_obs_associations poa on res.id=poa.record_id and poa.table_name='SRM_RESOURCES'
join nbi_dim_obs obs on poa.unit_id=obs.obs_unit_id
join prj_obs_types pot on pot.id=obs.obs_type_id
but i seems to be missing some rows that is being returned. Also, I see the issue was caused because of the NBI_DIM_OBS table join. What could cause rows missing is the NBI_DIM_OBS table when joined with resource table?
NOTE: I'm aware of the fact that it's data extraction job that updates this data extract table in Clarity. I tried running the job and still missing rows in nbi_dim_obs table.